windows上建立表空间
CREATE TABLESPACE "DAT"
    LOGGING
    DATAFILE 'C:\ORCL\ORADATA\DBMS\DAT00.DBF' SIZE 10M
    AUTOEXTEND
    ON NEXT  25M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT
    SPACE MANAGEMENT  AUTO;

Linux上建立表空间
CREATE TABLESPACE "DAT"
    LOGGING
    DATAFILE '/data/orcl/oradata/dbms/DAT00.DBF' SIZE 20M,
     '/data/orcl/oradata/dbms/DAT01.DBF' SIZE 20M
    AUTOEXTEND
    ON NEXT  250M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT
    SPACE MANAGEMENT  AUTO;

新建用户：
drop user OLDKIDS cascade;
CREATE USER "OLDKIDS"  PROFILE "DEFAULT"
    IDENTIFIED BY "OLDKIDS" DEFAULT TABLESPACE "DAT"
    ACCOUNT UNLOCK;
GRANT "CONNECT" TO "OLDKIDS";
GRANT "DBA" TO "OLDKIDS";
GRANT "RESOURCE" TO "OLDKIDS";

导入/导出
c:\orcl\dbms\bin\exp xxs/xxs@kuke owner=xxs file=xxs_20060805;
c:\orcl\dbms\bin\imp xnh/xnh@kuke fromuser=xnh touser=xnh file=xnh_20060805;

CREATE TABLESPACE "SMS_DATA"
    LOGGING
    DATAFILE '/data/orcl/oradata/dbms/sms_data.dbf' SIZE 20M
    AUTOEXTEND
    ON NEXT  50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT
    SPACE MANAGEMENT  AUTO;


drop user SMS cascade;
CREATE USER "SMS"  PROFILE "DEFAULT"
    IDENTIFIED BY "sms" DEFAULT TABLESPACE "DAT"
    ACCOUNT UNLOCK;
GRANT "CONNECT" TO "SMS";
GRANT "DBA" TO "SMS";
GRANT "RESOURCE" TO "SMS";