-
Coppying instance to another instance
HI Experts
Iwant to copy the one scema data to another intance ( running in another mechine)
How ill do that>
Advanced thanks
(donto say import and export)
some thing like transport tablespaces
Thanks & Regards
KVV
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.
HTH,
Erik
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.
MH
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|