我给你个例子,比如我要建一个mvb用户,默认表空间MVB_BUSDATA 临时空间为MVB_BUSTEMP先在D盘建个目录mvb\data然后在sq/plus下用system/manager登录 运行 CREATE TABLESPACE MVB_BUSDATA DATAFILE 'D:\mvb\DATA\MVBBUS01.ORA' SIZE 1000M; CREATE TABLESPACE MVB_BUSTEMP DATAFILE 'D:\mvb\DATA\MVBTEMP01.ORA' SIZE 500M; 建立表空间 然后建用户时连上表空间: CREATE USER "MVB" IDENTIFIED BY "MVB" DEFAULT TABLESPACE "MVB_BUSDATA" TEMPORARY TABLESPACE "MVB_BUSTEMP" PROFILE DEFAULT ACCOUNT UNLOCK; GRANT "CONNECT" TO "MVB" WITH ADMIN OPTION; GRANT "DBA" TO "MVB" WITH ADMIN OPTION; GRANT UNLIMITED TABLESPACE TO "MVB"; ALTER USER "MVB" DEFAULT ROLE ALL; CONN MVB/MVB;
运行 CREATE TABLESPACE MVB_BUSDATA DATAFILE 'D:\mvb\DATA\MVBBUS01.ORA' SIZE 1000M;
CREATE TABLESPACE MVB_BUSTEMP DATAFILE 'D:\mvb\DATA\MVBTEMP01.ORA' SIZE 500M;
建立表空间
然后建用户时连上表空间:
CREATE USER "MVB" IDENTIFIED BY "MVB" DEFAULT TABLESPACE "MVB_BUSDATA" TEMPORARY TABLESPACE "MVB_BUSTEMP" PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT "CONNECT" TO "MVB" WITH ADMIN OPTION;
GRANT "DBA" TO "MVB" WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO "MVB";
ALTER USER "MVB" DEFAULT ROLE ALL;
CONN MVB/MVB;
可是我在imp数据的时候还要建立表空间吗?