Re: [RE: COPY vs. INSERTS

From: Milan Rahman <milan_rahman_at_MailAndNews.com>
Date: Fri, 26 May 2000 13:56:28 -0400
Message-Id: <10509.106905@fatcity.com>

One important note regarding SQLPLUS COPY utility that can make this less utilitarian is as follows from SQL*Plus 3.1 User Guide and Reference: "Note: To enable the copying of data between ORACLE and non-ORACLE databases, NUMBER columns are changed to DECIMAL columns in the destination table. Hence, if you are copying between ORACLE databases, a NUMBER column with no precision will be changed to a DECIMAL(38) column. When copying between ORACLE databases, you should use SQL commands (CREATE TABLE AS and INSERT) or you should ensure that your columns have a precision specified."

Milan Rahman
Senior Oracle DBA
Oracle Applications DBA
SageLogix, Inc.
Greenwood Village, Colorado

http://www.sagelogix.com Received on Fri May 26 2000 - 12:56:28 CDT