Home » Server Options » Streams & AQ » advanced queue tables
advanced queue tables [message #36476] Thu, 29 November 2001 06:18 Go to next message
Chris
Messages: 128
Registered: November 1998
Senior Member
We created Advanced Queuing tables (in a default tablespace I think) but want to put the table data and the table indexes into 2 separate tablespaces. I believe the Alter Queue Table procedure doesn't handle talbespace changes. Anybody know how to do this ?

----------------------------------------------------------------------
Re: advanced queue tables [message #36479 is a reply to message #36476] Thu, 29 November 2001 06:51 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
follow these steps:
1)export all objects
2)alter user default tablespace to tablespace1;
2a)make original tablespace (object's current tablespace) offline
3)import all objects
4)drop indexes (leave tables)
5)alter user default tablespace to tablespace2;
6)import all objects
5)drop al tables (leave indexes)

if anybody is having better idea,its welcome

----------------------------------------------------------------------
Next Topic: advanced queue :::: HELP ME:::::
Goto Forum:
  


Current Time: Thu Mar 28 11:46:32 CDT 2024