Code Snippet

Just another Code Snippet site

export

[Oracle] Import/Export as dump

As sys/sysdba : Export : Import : Export Options : To change the export version : version_string example : 10.2 Import Options : To change destination tablespace add : (in this case, the following grant should be performed : grant imp_full_database to YOURUSER;) In case of multi schema : REMAP_TABLESPACE=(src1:dst1,src2:dst1,src3:dst1,src4:dst1) To change destination schema add […]

, , ,