Coppying instance to another instance
Iwant to copy the one scema data to another intance ( running in another mechine)
How ill do that>
(donto say import and export)
some thing like transport tablespaces
Thanks & Regards
Venkata vara Prasad Kosaraju
whats wrong with exp and import - thats what it is for ya know.
Could spool off the data to a csv file and use sqlldr but whats the big issue with exp/imp
You can use transportable tablespaces, but you must put the tablespace in question in read only mode. If this is your production db, then you have a problem.
Normal export is possible while users are present.
alter tablespace x read only;
and then something like:
exp transport_tablespace=Y tablespaces=x
and after that the same in imp.exe.
Use EXP HELP=Y and IMP HELP=Y in your command prompt for the complete set of parameters.
PS: Don't forget to write-enable the source ts...
PSPS: To my knowledge, this question was already solved once. Please try to search the site before posting your question. It saves you the time of typing your story
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
I would never say import/export, I would however suggest export/import, that would make a lot more sense.
I remember when this place was cool.
Click Here to Expand Forum to Full Width