0.启动oracle
lsnrctl start
export ORACLE_SID=ORACL
sqlplus / as sysdba
startup
1.用system账号登陆
sqlplus system/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