copy tablespace in one database

From: Wojciech Skrzynecki <wojciech.skrzynecki_at_gmail.com>
Date: Tue, 25 Mar 2008 21:50:40 +0100
Message-ID: <001801c88eb9$e7892d40$a400714d@allianz.local>


Hello  

I plan to copy data from all tables to the new tables in new tablespace every night. Why? Old tablespaces will be purged every night and I have to have old date

I think that I have two options:

First

I have to copy tablespace to the new with new name plus date e.g. tablespace "name" to the new name_date.

Second:

Create tables in new tablespace "as select" but what can I do with indexes?  

I do not know if first options is possible.  

Maybe you have any idea to help me.

Rgds.

Wojtek

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 25 2008 - 15:50:40 CDT

Original text of this message