Move Partition Example
The following statement moves partition depot2 to tablespace ts094:
ALTER TABLE parts
MOVE PARTITION depot2 TABLESPACE ts094 NOLOGGING;
The following statement moves partition depot2 to tablespace ts094:
ALTER TABLE parts
MOVE PARTITION depot2 TABLESPACE ts094 NOLOGGING;
还可以
alter table table_name move [tablespace tablespace_name
storage(initial 5M next 5M pctincrease 0 pctfree 10 pctused 50) nologging]
ALTER USER "USERNAME" DEFAULT TABLESPACE "SPACEDATA"
TEMPORARY TABLESPACE "SPACETEMP"USERNAME : 为用户名
SPACEDATA: 为表空间
SPACETEMP: 为临时表空间
-------------------------------------------------
EXP,IMP 是备份与恢复
http://www.oradb.net/expimp/expimp_011.htm