1、CREATE TABLESPACE name
DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\BOMC.DBF' SIZE 600M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
如:
create tablespace BOMS_302
DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\BOMC.DBF' SIZE 600M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
2、create user username identified by password default tablespace name temporary tablespace temp;
如:
create user boms301 identified by asiainfo default tablespace BOMS_302 temporary tablespace temp;
3、grant connect,resource,create public database link,create view,drop public database link to username;
如:
grant connect,resource,create public database link,create view,drop public database link to boms301;