Oracle learning Summary 9

Expdp/imdp, exp/IMP usage summary. Expdp/imdp can only be used on the server, and exp/IMP can both be used.

1 expdp
First, create directory
Create directory dump as 'e: \ dump ';
Grant permissions:
Grant read, write on directory dump to Scott;

Export table: expdp system/manager directory = dump dumpfile = A. dmp tables = Scott. Dept, Scott. EMP
Normal users can only export their own solution tables;

 

Export Scheme: expdp system/manager directory = dum dumpfile = A. dmp schemas = system, Scott

Export tablespace: expdp system/manager directory = dump dumpfile = A. dmp tablespace = user01

Export Database: expdp system/manager directory = dump dumpfile = full. dmp full = y
2 impdp
Import table:
Import the table to your own solution:
Impdp Scott/tiger directory = dump dumpfile = tab. dmp tables = DEP, EMP
Import to other solutions:
Impdp system/manager directory = dump dumpfile = tab. dmp tables = Scott. Dept, Scott. EMP

Remap_schema = SCOTT: System
Import solution:
Impdp Scott/tiger directory = dump dumpfile = schema. dmp schemas = Scott
Export tablespace:
Impdp system/manager directory = dump dumpfile = tablespace. dmp tablespace = user01
Import database:
Impdp system/manager directory = dump dumpfile = full. dmp full = y
3 exp
Table:
Exp system/manager @ demo tables = Scott. Dept, Scott. EMP file = tab1.dmp
Solution:
Exp system/manager @ demo owner = Scott files = test1.dmp
Database
Exp system/manager @ demo full = y file = full. dmp
4. Import
IMP Scott/tiger @ demo file = tab2.dmp tables = Dept
Import different tablespaces
IMP system/manager @ demo file = tab2.dmp tables = dept fromuser = Scott touser = System
Import Database
IMP system/manager @ demo file = full. dmp full = y

　

Multiple tools, easy to use
DBV is used to check whether blocks, data files, and other bad blocks exist.

DBV file = D: \ demo \ system01.dbf feedback = 1000 blocksize = 4096
A "." is displayed for each 1000 blocks, indicating the progress. blocksize indicates the size of the specified data block. The default value is 2048.