Oracle Database Operations Daquan (10)--logical backup and recovery of database (table)

Logical backup and Recovery of database (table)--Export

System can export any scenario, for example:

Exp System/[email Protected] Owner (System,scott) file=d:system.dmp;//Note: Two scenario system scenarios and Scott scenarios can be exported

exp System/[email Protected] Owner (Scott) file=d:system.dmp;//can only export the Scott scheme ( This is the use of the system to export the Scott scheme, Reason: System privilege is higher than Scott), export the scheme with a higher permission than to export the user to export

Exp System/[email protected] owner (SYS) file=d:system.dmp;//cannot properly export the SYS scheme at this time, because system user rights are lower than SYS user

Export of the database: ( Export all scenarios )

Exp Userid=system/[email protected] full=y inctype=complete file=d:\aa.dmp

(Operating under the Bin folder of the installation directory),

After entering the export statement:

*** 1. Export the table

Logical backup and Recovery of database (table)--Database import

1. Importing Tables

(where m123 is the password for the Scott user, Myoral is the DB instance, the table to be imported is EMP and its backup is EMP.DMP)

*** 2. Importing Scenarios

3. Import the Database

Oracle Database Operations Daquan (10)--logical backup and recovery of database (table)