INSERT INTO table1@link SELECT * from table1The WHERE condition works fine, but does not do a "deep copy." Is there an easy way to do this or a tool I can use?
I would generate a script that reads the data dictionary to create the move syntax. Something like this:
spool runme.sql select 'create table '||table_name||'@dblinkname as select * from '||table_name'||';' from dba_table where owner = 'SCOTT'; spool off; @runme
Dig Deeper on Oracle and SQL
Related Q&A from Don Burleson
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed... Continue Reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.