00036.Oracle扩展表空间

Alter tablespace IMUSE01add datafile

 '/opt/oracle/oradata/orcl/imuse01_dat5' size 8G

Alter tablespaceIMUSE01 add datafile

 '/opt/oracle/oradata/orcl/imuse01_dat8' size 5000MREUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED

CREATE TABLESPACE imuse02 

   DATAFILE '/u01/app/oradata/mdsp/imuse02.dbf' SIZE 50000M

   REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE 320000M  nologging;

Create user imuse02 identified by imuse02;

ALTER USER imuse02  DEFAULTTABLESPACE imuse02