HELP: Copying Tablespaces within Oracle 8.1.7

From: Bob <bob_at_hotmail.com>
Date: Wed, 05 Mar 2003 00:20:22 GMT
Message-ID: <m8ga6vc6pq505h5shpufo1vujvk8cb06kv@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 Tue Mar 04 2003 - 18:20:22 CST