登录服务器切换oracle数据库做事前查询与执行sql:
su - oracle
$sqlplus /nolog
SQL> conn / as sysdba
查询用户所在表空间:
select * from dba_users where username = ‘USERDB’;
select default_tablespace from dba_users where username = ‘USERDB’;
查询directory路径:
select * from dba_directories;
新建directory路径:
create directory DATA_PUMP_DIR as ‘/u01/app/oracle/DATA_PUMP_DIR’;
回到oracle用户执行导出:
expdp userDB/userDB directory=DATA_PUMP_DIR dumpfile=userDB20200407.dmp schemas=USERDB logfile=data.log
登录导入服务器切换oracle数据库做事前查询与执行sql:
su - oracle
$sqlplus /nolog
SQL> conn / as sysdba
创建表空间:
create tablespace USERDB logging datafile’/home/oracle/oradata/ora11g/USERDB.dbf’ size 1024m autoextend on next 100m maxsize 10240m extent management local;
创建用户:
create user userDB identified by userDB default tablespace USERDB