Analysis of IMPEXP Commands

xiaoxiao2021-03-06  90

Back up one or more users D: /> EXP Scott / Tiger file = Export file D: /> Exp System / Manager Owner = (User 1, User 2, ..., User N) File = Export file backup one or more tables D: /> EXP User / Password Tables = Table D: /> EXP User / Password Tables = (Table 1, ..., Table 2) D: /> Exp System / Manager Tables = (User. Table) D: /> EXP System / Manager Tables = (User 1. Table 1, User 2. Table 2) Import Specify Table D: /> Exp Scott / Tiger File = a.dmp D: /> IMP Test / Test fromuser = Scott Tables = EMP File = A.dmpd: /> IMP TEST / TEST TABLES = Dept File = a.dmp Description: If the user does not have DBA permissions, import users can use the fromUser, the Touser parameter If the export user has DBA permissions, import users must have DBA Permissions Log Information IMP80 Username / Password @ alias file = ompfile.dmp log = mylog.log exp80 username / password @ alias file = express.dmp log = mylog.log

All log information is recorded in myLog.log after running.

转载请注明原文地址:https://www.9cbs.com/read-123075.html

New Post(0)