Copying data from one schema to another [message #9012] |
Fri, 10 October 2003 13:11 |
Nacbou
Messages: 3 Registered: October 2003
|
Junior Member |
|
|
I have a problem copying data from one schema to another one .
Here is my script
SQL> COPY FROM Schema01/Passwrd@Service -
> INSERT ORDERS (X1) -
> USING SELECT Y1 FROM OrigTable;
Here is what i get from oracle :
Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
SELECT X1 FROM OrigTable
*
Error in SELECT statement: ORA--1002: Message -1002 not found; product=RDBMS; facility=ORA
Can anyone help me .Thinks
|
|
|
Re: Copying data from one schema to another [message #9016 is a reply to message #9012] |
Fri, 10 October 2003 17:55 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Are you fetching the data across 8.0.6/8.1.5 databases? It seems there are couple of Oracle bugs related to this and is solved by applying the necessary patches.
Workaround is to copy the data over database link.
-----------------------
Bug 644413 OCIStmtPrepare does not call the server - DDL not executed
This note gives a brief overview of bug 644413.
Affects:
Product (Component) Oracle Server (RDBMS)
Range of versions believed to be affected Versions < 8.1.5
Versions confirmed as being affected
* 8.0.6.0
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
* 8.0.6.1 (Server Patch Set)
* 8.1.5.0 (Base Release)
Symptoms:
* (None Specified)
Related To:
* OCI
Description
OCIStmtPrepare does not call the server - Hence DDL is not executed
by calling this routine. This impacts some tools such as SQLPLUS copy.
------------------------------------------
|
|
|
|