SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to insert records from one databse to another database without DB link

kn_sivaramanOct 21 2009 — edited Oct 21 2009

hi,

how to insert records from one databse to another database without DB link,i have used below commands in sql*plus,

copy from siva4/siva4@fromdb create emp_HOLIDAY_LIST using select * from emp_HOLIDAY_LIST;

i got below error,

ERROR:
ORA--17239232: Message -17239232 not found; product=RDBMS; facility=ORA

can any one give some ideas of copy command with examples.

By
Siva

Edited by: kn_sivaraman on Oct 21, 2009 12:12 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2009

Added on Oct 21 2009

17 comments

960 views