RE: *****SPAM***** copy tablespace in one database
From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 26 Mar 2008 14:53:40 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902202706@usahm208.amer.corp.eds.com>
Date: Wed, 26 Mar 2008 14:53:40 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902202706@usahm208.amer.corp.eds.com>
Have you considered exporting the data (exp or expdp depending on Oracle version)?
- Mark D Powell --
Phone (313) 592-5148
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wojciech Skrzynecki
Sent: Tuesday, March 25, 2008 4:51 PM To: oracle-l_at_freelists.org Subject: *****SPAM***** copy tablespace in one database Hello I plan to copy data from all tables to the new tables in newtablespace 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-lReceived on Wed Mar 26 2008 - 13:53:40 CDT