Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • Good Doc 28-JUN-2006 Oracle
  • move_arch_files.ksh Linux/Unix
  • Export Import with QUERY Oracle
  • Guide to Linux System Command Mastery Linux/Unix
  • setting prompt display with .profile Linux/Unix
  • Sort with ASCII order and Numeric Order Linux/Unix
  • Query to Generate aggregate on every 30 mins. Oracle
  • set_env_dba Linux/Unix
  • Histogram information Oracle
  • Search and replace editor command in vi Linux/Unix
  • When to rebuld B-tree index Oracle
  • How to connect to Oracle Database with Wallet with Python. Oracle
  • Unix split command to split files Linux/Unix
  • normal maintenance for exp-imp and renaming table Oracle

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

  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • logminer and my_lbu Oracle
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • ORA-3136 Oracle
  • V$transaction notes for finding XID composition. 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • metalink all dynamic view reference notes. Oracle
  • Insert cause enqueue locks Oracle
  • Search and replace pattern Linux/Unix
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • How to stop OCSSD Daemon Oracle
  • get_vmstat_linux Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • Find Stale DR Physical Standby Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme