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.