alter tablespace 表空间

select b.*,a.* from v$datafile a,V$dbfile b

where a.FILE# = b.FILE#

 

select 1572864000/1024/1024 from dual

 

alter tablespace gau12d

add datafile 'gau12d_02.dbf' size 1500m

8888888888888888888888888888888888888888888888888888888

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.