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.
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.
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?
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
A Winner never Quits, A Quitter never Wins
Ganesh .R
[QUOTE][i]Originally posted by aarganesh [/i]
[B]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 [/B][/QUOTE]
Hi ganesh
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?
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.
[url]http://www.dbasupport.com/forums/showthread.php?threadid=5221[/url]
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.
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.
Reply With Quote
Bookmarks