copy tablespace in one database
- From: "Wojciech Skrzynecki" <wojciech.skrzynecki@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 Mar 2008 21:50:40 +0100
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
Other related posts:
