Oracle 11G 创建scott用户
$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 29 15:51:36 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> CREATE TABLESPACE SCOTT_TBS DATAFILE '/u01/oradata/leadercoo/scott_tbs01.dbf' size 100m;Tablespace created.SQL> ALTER USER SCOTT DEFAULT TABLESPACE SCOTT_TBS QUOTA UNLIMITED ON SCOTT_TBS;User altered.SQL> REVOKE UNLIMITED TABLESPACE FROM SCOTT;Revoke succeeded.
?
?
?
