2010年
-
编辑 删除
ORACLE 10G expdp/impdp
--两库tablespace要一样c:>expdp help=y c:>impdp help=y SQL> create directory exp_dump as 'd:exp_dump';SQL> grant read, write on directory exp_dump to ...Importing Full Dump FileIf you want to Import all the objects in a dump file then you can type the following command. $impdp hr/hr DUMPFILE=dpump_dir1:expfull.dmp FULL=y LOGFILE=dpump_dir2:full_imp.logImporting Objects of One Schema to another SchemaThe following example loads all tables belonging to hr schema to scott schema$impdp SY
-
编辑 删除
HELLO
Hello, EveryoneStarting today, I will record my feeling during my life, work, and so on ... [@more@]
