OraFAQ Forum: SQL & PL/SQL » Problem with Copying data from a Remote Database to Local Database

Home » SQL & PL/SQL » SQL & PL/SQL » Problem with Copying data from a Remote Database to Local Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with Copying data from a Remote Database to Local Database [message #298027]

Mon, 04 February 2008 12:11

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

Report message to a moderator

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 19:01:41 CST 2025