To execute a table mode export:exp username/password tables=table1,table2,table3 … file=export_file_name To execute a user mode export:exp username/password owner=schema_name file=export_file_nameTo export only the data definitions without the data:exp username/password owner=schema_name rows=n file=export_file_nameTo export a users objects but not the grants to those objects:exp username/password owner=schema_name grants=n file=export_file_name
c:\>exp system/password@cp2003 owner=cp01 file=d:\expdb_user\cp01_Exp.dmp log=d:\expdb_user\cp01_Exp.log
c:\>imp system/password@cp2003 file=d:\expdb_user\cp01_Exp.dmp log=d:\expdb_user\cp01_imp.log fromusr=cp01 touser=cp02 buffer=64000 commit =y
IGNORE=Y
TABLES=(EXPENSES, ADVANCES)
FULL=N
然后,你再在command窗口,运行exp或imp。
试试去吧
安装oracle时安装的
imp和exp 在DOS命令行下运行