Home » SQL & PL/SQL » SQL & PL/SQL » Problem with Copying data from a Remote Database to Local Database
Problem with Copying data from a Remote Database to Local Database [message #298027] Mon, 04 February 2008 12:11 Go to next message
ramsatish
Messages: 8
Registered: November 2006
Junior Member
I am working on Oracle8i.

My requirement is to copy data from remote database to local database.For that i am using the command below

COPY FROM sri/AC12ER@BNNF -
CREATE emp_new -
USING select * from EMPLOYEES


The above command is giving the error below

Statement Ignored
CREATE emp_new -
USING select * from Employees
ORA-00901: invalid CREATE command

Thanks in Advance

Regards,
Sriram Satish
Re: Problem with Copying data from a Remote Database to Local Database [message #298028 is a reply to message #298027] Mon, 04 February 2008 12:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read the title of each forum and choose the correct one.
Do you really think "Post your feedback and suggestions here." is the correct forum to post your question?

Also please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code.
Use the "Preview Message" button to verify.
Always post your Oracle version (4 decimals).

Create a database link and use "create table ... as select ... from mytable@remotedblink"

Regards
Michel
Re: Problem with Copying data from a Remote Database to Local Database [message #298031 is a reply to message #298027] Mon, 04 February 2008 12:30 Go to previous messageGo to next message
ramsatish
Messages: 8
Registered: November 2006
Junior Member
Hi Michel Cadot,
Thanks for your reply.If this is not the correct forum for my question please redirect my question to the correct forum.
I tried with DBLink but it is taking a lot of time to execute the query.
My requirement is to fire the same query on a number of oracle instance.
I am using oracle 8i
Please guide me if can do this task using Oracle SQL*Plus copy command.
Regards,
Sriram Satish
Re: Problem with Copying data from a Remote Database to Local Database [message #298032 is a reply to message #298031] Mon, 04 February 2008 12:37 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If this is not the correct forum for my question please redirect my question to the correct forum.

This is what I've done but you have to realize that moderators have other things to do than move topic of fellows that don't care where they post.

SQL*Plus copy command uses a db link.
And its syntax is in the documentation: SQL*Plus COPY Command
But take care of this warning:
Quote:
The COPY command will be obsoleted in future releases of SQL*Plus. No new datatypes will be supported by COPY.


Regards
Michel

[Updated on: Mon, 04 February 2008 12:38]

Report message to a moderator

Previous Topic: what datatype is used to handle a very large string
Next Topic: ORA-06502: PL/SQL: numeric or value error using Bulk
Goto Forum:
  


Current Time: Wed Dec 07 12:20:02 CST 2016

Total time taken to generate the page: 0.07430 seconds