Current location - Quotes Website - Team slogan - Oracle Export Tables = () Slogantable Can you write an sql to check all tables?
Oracle Export Tables = () Slogantable Can you write an sql to check all tables?
= = Export a complete database [structure+data] = = = = = =

Exp system/password file =/u01/2010115.dmplog =/u01/2010/kloc.

= = Only export the structure of the database, not the data inside = = = = =

Exp system/password file =/u01/201015. dmplog =/u01/201/kloc.

= = Export all data of user admin = = = = = = =

Exp system/password file =/u01/2010115.dmp log =/u01/2010/kloc.

= = For example, export all objects of both administrator and visitor users = = =

exp system/password file =/u 0 1/20 10 1 15 . DMP log =/u 0 1/20 10 1 1 1 15 . log owner =(admin,visitor)

= = Only one table is exported, for example, only the testtable table under the admin user is exported =

exp admin/admin password file =/u 0 1/20 10 1 15 . DMP log =/u 0 1/20 10 1 1 165438 . log tables = test table

= = If multiple tables need to be exported = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

Expadmin/adminpassword file =/u0 1/201015. dmplog =/u01/2010/kloc.

Exp system/password file =/u01/201015. DMP log =/u01/2010/kloc.

If you have to export the specified table, how will it know which tables to export if you don't give it a name:)

So there seems to be no good way for table to lose one by one.