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
Printable View
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
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
Use Exp/Imp option.
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... :p
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 ;)
I would never say import/export, I would however suggest export/import, that would make a lot more sense.
:D
MH