查询表空间 &[ schema

select  * from dba_tablespaces

 

create table xxx(xxx) tablespace xxx

 

CREATE TABLESPACE "GAU02I" DATAFILE
  'GAU00T_gau02i01.dbf' SIZE 1677721600 REUSE
  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

 

[root@gaudi ~]# su - oracle

[oracle@gaudi ~]$ sqlplus "/ as sysdba"

 

SQL*Plus: Release 9.2.0.4.0 - Production on  Dec 10 10:21:12 2008

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

 

SQL> create user lkg identified by lkg;

 

User created.

 

SQL> grant connect,resource to lkg;

 

Grant succeeded.

 

SQL> alter user lkg default tablespace gau01d;

 

User altered.