var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Copy tables to another database
I want to copy tables from one database to another *using query*. Note that the other database can be local or remote.
I know how to do this using COPY command.
1. I don't know much about database link. Can this be done using database link? How?
2. Would database link method be faster than COPY command.
You will have to have a database link between the 2 databases in question.
You can then use:
create table tablename as select * from firstname.lastname@example.org
... This is a nologging event so it is pretty quick ... depending on the size of the table you are copying and the amount of data to pull thru the link.
You could also use exp/imp from database to database