Hi,
use the copy of prod's datafiles to create the second prod with another
instance name(because same instance names cannot reside on same machine) by
recreating controlfile.
hopt this is helpful.
tommy
"Bob" <bob_at_hotmail.com> ?????
news:m8ga6vc6pq505h5shpufo1vujvk8cb06kv_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 Tue Mar 04 2003 - 20:42:46 CST
