Home » SQL & PL/SQL » SQL & PL/SQL » Copying data from one schema to another
Copying data from one schema to another [message #9012] Fri, 10 October 2003 13:11 Go to next message
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 Go to previous messageGo to next message
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.
------------------------------------------
Re: Copying data from one schema to another [message #9050 is a reply to message #9016] Wed, 15 October 2003 10:05 Go to previous message
Nacbou
Messages: 3
Registered: October 2003
Junior Member
I used sql*Plus Release 9.0.1.0.1 on the client Side
And I have installed oracle8i Stanrdard Edition Release 3 (8.1.7) on the server side.
Previous Topic: Compiling package with debug in 9.2
Next Topic: Copying data
Goto Forum:
  


Current Time: Thu Mar 28 07:02:16 CDT 2024