If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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

Ricky,
I am with Halo, If you are not able to export/import then try with copy command. With compare to create table as select ,COPY command is faster. For this you don't need to create a db link also. Just it will see the database name in your tnsnames.ora. So Good Luck.