1、创建表空间--user: system
create tablespace TESTBBS datafile 'THINKIVEDATA.dbf' size 1000M;
2、创建用户
create user bbs
identified by bbs
default tablespace TESTBBS
3、赋予权限
grant connect,resource to bbs;
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,CREATE ANY synonym,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO bbs;
4、导入表:
imp bbs/bbs@orcl file=D:\table\test.dmp log=D:\table\log.txt full=y ignore=y
create tablespace TESTBBS datafile 'THINKIVEDATA.dbf' size 1000M;
2、创建用户
create user bbs
identified by bbs
default tablespace TESTBBS
3、赋予权限
grant connect,resource to bbs;
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,CREATE ANY synonym,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO bbs;
4、导入表:
imp bbs/bbs@orcl file=D:\table\test.dmp log=D:\table\log.txt full=y ignore=y