|
|
Re: tables in non-default tablespace [message #942 is a reply to message #939] |
Thu, 14 March 2002 10:47 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
There is no such command.
I recommand you to use the view user_segments to create a script which will delete all the related tables. For example
select 'DROP TABLE '|| SEGMENT_NAME ||';' from user_segments where tablespace_name <>'YOUR_DEFAULT_TS';
You may have to use the drop table option CASCADE CONSTRAINTS (be carefull with it).
HTH
Mike
|
|
|
Re: tables in non-default tablespace [message #957 is a reply to message #939] |
Fri, 15 March 2002 04:43 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
You can move tables and indexes to your default tablespace.
alter TABLENAME move tablespace TABLESPACENAME;
alter index INDEXNAME rebuild tablespace TABLESPACENAME;
|
|
|