oracle 11g 基本操作代码

一。创建表空间

CREATE TABLESPACE ACTIVESP1
DATAFILE 'E:\oracle\product\10.2.0\oradata\orcl\ACTIVESP1.DBF' SIZE 500M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/
CREATE TABLESPACE ACTIVESP2
DATAFILE 'E:\oracle\product\10.2.0\oradata\orcl\ACTIVESP2.DBF' SIZE 5000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/

CREATE TABLESPACE INDEXSP
DATAFILE 'E:\oracle\product\10.2.0\oradata\orcl\INDEXSP.DBF' SIZE 50M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/

CREATE TEMPORARY TABLESPACE TEMPSP
TEMPFILE 'E:\oracle\product\10.2.0\oradata\orcl\TEMPSP.DBF' SIZE 300M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
/

二。创建用户

CREATE USER WX
IDENTIFIED BY SA
DEFAULT TABLESPACE ACTIVESP1
TEMPORARY TABLESPACE TEMPSP
PROFILE DEFAULT
/
GRANT DBA TO WX WITH ADMIN OPTION
/
GRANT UNLIMITED TABLESPACE TO WX WITH ADMIN OPTION
/