导出:
exp ANYOA/ANYOA@databasename file=test.dmp
创建用户:
create user username
identified by password
grant dba on databasename to username;
导入:
imp username/password@databasename file=test.dmp log=test.log fromuser=ANYOA touser=username
exp ANYOA/ANYOA@databasename file=test.dmp
创建用户:
create user username
identified by password
grant dba on databasename to username;
导入:
imp username/password@databasename file=test.dmp log=test.log fromuser=ANYOA touser=username
create user username
identified by password
default tablespace system;grant dba on databasename to username;