Printable View
The problem is that I am new to the field of ORACLE administration. I have an existing database with certain characteristics that I need to duplicate to be able to use ALL of its structure. The idea that I have to do it is to create a database and then do an IMPORT of the existing one but I really don't know if that would be enough.
PLEASE I need any help I can get. Thank you for your time.
Yes !
That would be enough . You can create a new database and create the same users as the existing database and then take an export from the existing one and import it in this. This should sought out your problem of duplicating the databases.
Thanx Puneet!
I'll try that then. One more thing though, would I have to create similar control files and log files and data files, or would that be included in the export? And do you know anything about the table spaces? are they included too?
Thanks again, I really appreciate your help.
Follow this link which talks about the general steps for exp/imp
http://www.dbasupport.com/forums/sho...?threadid=5221
Hi,
I think the ideal solution, incase if you mean that U want to copy the entire database including the name sid etc, then it's better for you to just shutdown the database and copy all the control files, data files and the log files to another machine with the same location specified in the existing one. This way the copying becomes very very easy and acquires less time.
Rgds
Ganesh .R
Hi ganeshQuote:
Originally posted by aarganesh
Hi,
I think the ideal solution, incase if you mean that U want to copy the entire database including the name sid etc, then it's better for you to just shutdown the database and copy all the control files, data files and the log files to another machine with the same location specified in the existing one. This way the copying becomes very very easy and acquires less time.
Rgds
Ganesh .R
I went through your suggestion of maintaining two databases, I have a question with you can you give me the details about the colums the view sm$version give when it is queried and also what is difference between v$version and sm$version
Hey sreddy! Thanks for yoru help. I read your steps for exp/imp and I was wondering. The thing is that I have to have two data bases with the exact same structure and everything but they're gonna hold different data. I already have one that's going to be emptied out and I need to sort of duplicate that. Should I first CREATE a new DataBase with the same characteristics for their table spaces, log files, control files and data files and then do the import?Quote:
Originally posted by sreddy
Follow this link which talks about the general steps for exp/imp
http://www.dbasupport.com/forums/sho...?threadid=5221
Thanks again for your help and sorry for any inconvenience.
You will be okey, as longs your tablespace names are not changed. No matter how import it. You can always truncate all the table and reload 'em with imp/rows=y.
So, I don't see any problem here. If you want do it in 2 steps
Step-1:all the object structures will be created
rows=n
step-2:Just loads the data
rows=y
Make sure you sync this link details with above options.
http://www.dbasupport.com/forums/sho...?threadid=5221
Bottom Line, you need to have precreated tablespaces on the database you are trying to import. Because most of the filesystems and available freespace will not same from box to box. If you don't create and import, if fails when it tries to create that tablespace and can't find the same fileystem.
Just for that reason you create tablespaces upfront.
[Edited by sreddy on 01-17-2001 at 02:45 PM]
how will you be loading the data after creating the database ?
from dump file ? using scripts ? using sqlloader ? how ?
I don't have to load the data because all I need is the database structure. I need to have 2 databases with the same structure but they're gonna be used for different information. The records that will be registered in on table won't be the same as the other. So I need all the TRIGGERS, all the TABLES, all the STRUCTURES but not the information. Oh! and they have to reside on the same computer.
Thanks for your help!
You don't need to worry about anything then. Just take full export and full import with rows=n. that should take s care off.
$exp system/**** buffer=9999 full=y rows=n consistent=y
$imp system/**** buffer=9999 full=y rows=n ignore=y
thats all about it, don't forget about precreated tablespaces.
ALTERNATIVE(if you think your database is big for exp/imp) IS:.
Create the new database from cold backup and truncate all the tables data using dynamic sql script.
[Edited by sreddy on 01-18-2001 at 10:00 AM]