|
-
Create table as select ... using a db link would work, but will take a long time. Have the DBA export/import the table. If you have a db link between the 2 databases, then use the copy command to copy the table across, in the following manner:
1. login as the user in the target db
2. precreate the table
3. (copy command syntax)
set copycommit 1;
set arraysize 1000;
copy -
from username1/password1@source_db -
to username2/password2@target_db -
insert target_table_name using -
select * from source_table_name
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|