1. In the same server table structure and to copy the data?
2. Different table structure and how the data replication server?
3. Copy after finished before the corresponding main foreign key relationships in the table and index

CodePudding user response:

If it is a single table or a small amount of a few tables, you can use the create table t1 as select * from t2; Index, foreign keys, etc should be re-established
If it is all the tables and objects, under a user can use expdp, impdp export import form, at this point, the indexes and foreign keys can be synchronous import
Whether the difference on a server,

CodePudding user response:

reference 1st floor jdsnhan response:

if it is a single table or a small amount of a few tables, you can use the create table t1 as select * from t2; Index, foreign keys, etc should be re-established
If it is all the tables and objects, under a user can use expdp, impdp export import form, at this point, the indexes and foreign keys can be synchronous import
Whether the difference is not big, on a server

Can I use PLSQL import and export in a selected user dozens of watch? But not all of the watch?

CodePudding user response:

refer to the second floor jushihua4293 response:

Quote: refer to 1st floor jdsnhan response:

If it is a single table or a small amount of a few tables, you can use the create table t1 as select * from t2; Index, foreign keys, etc should be re-established
If it is all the tables and objects, under a user can use expdp, impdp export import form, at this point, the indexes and foreign keys can be synchronous import
Whether the difference is not big, on a server

Can I use PLSQL import and export in a selected user dozens of watch? But not all of the watch?

Export is certainly can, just select the specified, import directly to modify the SQL file comments or you don't need to delete it

CodePudding user response:

refer to the second floor jushihua4293 response:

Quote: refer to 1st floor jdsnhan response:

If it is a single table or a small amount of a few tables, you can use the create table t1 as select * from t2; Index, foreign keys, etc should be re-established
If it is all the tables and objects, under a user can use expdp, impdp export import form, at this point, the indexes and foreign keys can be synchronous import
Whether the difference is not big, on a server

Can I use PLSQL import and export in a selected user dozens of watch? But not all of the watch?

Can the