Search Results

Hello,
why don't you use the Oracle SQL-Developer.
Connect to prod_db
Use export function to export a table, db, sheme ....
Connect to dev_bd
Import by using the file created in 2.

...

Or, how about connecting to the dev server, setting up a database link and issuing:-
CREATE TABLE dev_table AS SELECT * FROM source_table@my_db_link ;

This would drag the table direct between the...

This is certainly a valid way of moving data from one database to another. The only downside is that you would
need to manually created indexes, constraints and triggers. Once the table gets...