导入数据库
使用系统用户system即可创建一个用户
create user uname identified by psw default tablespace tsp01 temp tablespace temp;
grant connect,create session to uname;
使用系统用户system即可创建一个用户
create user uname identified by psw default tablespace tsp01 temp tablespace temp;
grant connect,create session to uname;
DEFULT TABLESPACE tablespace_name;GRANT CREATE SESSION TO user_name;GRANT DBA TO user_name;EXP/IMP --导出导入数据
1.create tablespace xxx
2.create user ... TABLESPACE xxx
3.GRANT ...
4.net configuration ....aaa
5.在command下:imp user/pwd@aaa
6.ok