Home -> Usenet -> comp.databases.oracle -> HELP: Recreating or copying tablespaces in Oracle 8.1.7?

HELP: Recreating or copying tablespaces in Oracle 8.1.7?

From: Bob <bob_at_hotmail.com>
Date: Wed, 05 Mar 2003 00:20:53 GMT
Message-ID: <3hga6vovrl4b6sb3t3ubrggii1vb665lik_at_4ax.com> 






Dear Group:



I am running Oracle 8.1.7 (non-enterprise) on Windows NT 4.0 SP5 and I
am wondering if there are any automated batch commands or scripts in
SQL that will allow me to copy existing tablespaces within the *same*
global database. For example, we have 4 extents (Prod, Pilot, Demo and
Test) and I want to make duplicate copies of "Prod" within the same
RDBMS. Is there a way to automatically recreate a second copy of
"Prod", with the related IDX and TEMP tablespaces (with all of the
tables / data). Any help would be greatly appreciated, I am a newbie
at this.



PEACE

Received on Wed Mar 05 2003 - 01:20:53 CET












Original text of this message