Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • sess1.sql Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • Exadata Basics Oracle
  • Find Plan Hash value fphv.sql Oracle
  • Implementing Listener Security Oracle
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • Sample WW22 listener.ora Oracle
  • useful dg links Oracle
  • Unix split command to split files Linux/Unix
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • load SPM baseline from cursor cache Oracle
  • PHP code to add WordPress posts in bulk programmatically PHP/MYSQL/Wordpress
  • Drop specific SQL plan baseline – spm Oracle
  • Library cahe Latches and internal explaination Oracle
  • fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix

SQLPLUS COPY command Precautions.

Posted on 01-Dec-2005 By Admin No Comments on SQLPLUS COPY command Precautions.

One test case today i found with copy command.

When we are using sqlplus copy command with “APPEND” clause, and if source table contains any NUMBER datatype without Precision and Scale, then COPY statement fails with error indicating “NUMERIC ERROR and Number data type precision is higher than 38 digit”.

Oracle, SQL scripts

Post navigation

Previous Post: Optimizer_Index init.ora parameter explaination.
Next Post: Index Range Scan

Related Posts

  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • oracle fast start failover best practice Oracle
  • How to Modify the statistics collection by MMON for AWR repository Oracle
  • find_cons.sql Oracle
  • Find all users who have DML privileges Oracle
  • Jai Shree Ram Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Implementation of key based authentications Linux/Unix
  • All Hints for Oracle Databases Oracle
  • grep multuple patterns Linux/Unix
  • Reading config file from other folder inside class Python/PySpark
  • Database logon trigger issue Oracle
  • findobj.sql Oracle
  • Database link password in user_db_links Oracle
  • Sort with ASCII order and Numeric Order Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme