导出:
导入:
导出整个用户:
导入整个用户:
exp user/password@schema rows=y indexes=n triggers=n constraints=n grants=n buffer=640000 file=YourTableName.dmp tables=(YourTableName);
导入:
imp userpassword@schema fromuser=user touser=user ignore=y commit=y buffer=640000 file=YourTableName.dmp tables=(YourTableName);
导出整个用户:
exp user/password@schema owner=(user); file=schema.dmp
导入整个用户:
imp user/password@schema file=schema.dmp fromuser=user_old touser=user_new rows=y indexex=y;