Coppying instance to another instance

[prasadkvv]

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

[davey23uk]

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

[vishal sood]

Use Exp/Imp option.

[efrijters]

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

[Mr.Hanky]

I would never say import/export, I would however suggest export/import, that would make a lot more sense.



MH