oracle 11g 基本操作代码

来源：互联网发布：类似知乎的网站源码编辑：程序博客网时间：2024/05/22 16:42

一。创建表空间

CREATE TABLESPACE ACTIVESP1DATAFILE 'E:\oracle\product\10.2.0\oradata\orcl\ACTIVESP1.DBF' SIZE 500M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITEDLOGGINGONLINEBLOCKSIZE 8KEXTENT MANAGEMENT LOCAL AUTOALLOCATESEGMENT SPACE MANAGEMENT AUTO/CREATE TABLESPACE ACTIVESP2DATAFILE 'E:\oracle\product\10.2.0\oradata\orcl\ACTIVESP2.DBF' SIZE 5000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITEDLOGGINGONLINEBLOCKSIZE 8KEXTENT MANAGEMENT LOCAL AUTOALLOCATESEGMENT SPACE MANAGEMENT AUTO/CREATE TABLESPACE INDEXSPDATAFILE 'E:\oracle\product\10.2.0\oradata\orcl\INDEXSP.DBF' SIZE 50M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITEDLOGGINGONLINEBLOCKSIZE 8KEXTENT MANAGEMENT LOCAL AUTOALLOCATESEGMENT SPACE MANAGEMENT AUTO/CREATE TEMPORARY TABLESPACE TEMPSPTEMPFILE 'E:\oracle\product\10.2.0\oradata\orcl\TEMPSP.DBF' SIZE 300M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED/

二。创建用户

CREATE USER WXIDENTIFIED BY SADEFAULT TABLESPACE ACTIVESP1TEMPORARY TABLESPACE TEMPSPPROFILE DEFAULT/GRANT DBA TO WX WITH ADMIN OPTION/GRANT UNLIMITED TABLESPACE TO WX WITH ADMIN OPTION/