RE: *****SPAM***** copy tablespace in one database

From: Powell, Mark D <>
Date: Wed, 26 Mar 2008 14:53:40 -0400
Message-ID: <>


Have you considered exporting the data (exp or expdp depending on Oracle version)?

  • Mark D Powell -- Phone (313) 592-5148

[] On Behalf Of Wojciech Skrzynecki

	Sent: Tuesday, March 25, 2008 4:51 PM
	Subject: *****SPAM***** copy tablespace in one database


	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:          


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


        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.          



Received on Wed Mar 26 2008 - 13:53:40 CDT

Original text of this message