ORACLE导入导出

0.启动oracle

lsnrctl start

export ORACLE_SID=ORACL

sqlplus / as sysdba

startup

1.用system账号登陆

sqlplussystem/NE@ORACL

2.创建表空间

create tablespace TS_APP datafile  '/oradata/ntorcl1/TS_APP.ora'  size 100m;

3.修改表空间位自增

ALTER DATABASE DATAFILE '/oradata/ntorcl1/TS_APP.ora' AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;

4.创建用户并指定表空间和授权

create user user_app identified by user_app default tablespace TS_APP

grant dba to user_app;

5.导出

exp user_app/user_app@ORACL file=/app/orclDATA/user_app.dmpfull=y

6.导入

impuser_app/user_app@ORACL file=/app/orclDATA/user_app.dmpfromuser=user_app touser=user_app