if you have existing dump files then import them into new database, or other wise create users and tables as per your requirement, don't forgot to observe the tablespace sizes...

Thanks for Reply, Ya my server has to run 24X7, right now we are using the method cold backup for recovery, we stopped to take logical backup using EXP and IMP, as my production database is around 35GB, for EXP it is taking 5 hrs time and for IMP it is taking 24hrs. So we moved to cold backup, right now as i joined new i preferred to take recover production database using archives, for that i am trying to recover database using archives. What my...

Ya i can do that but while executing EXP the server becoming very slow and cpu usage is going HIGH (100%) and the users which making complaint that the program is very slow.. thats why we are in proposal to update data to test database server via archives... pls suggest me......

Dear All,

I am new to this Forum, what my prob in ORACLE 8I i have primary database i am trying to put all the data in test database which was not in network for that i am using archive logs. The procedure what i am doing is

Taking cold backup(Oradata Folder) from primary database and copying the same in test database in place of Oradata folder, after that for every one hour i am getting archives from primary db to...