Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : RPOS

You know How to create a dump in oracle?

You know How to create a dump in oracle?

Solution :

Export Dump in Oracle :

Windows:

exp userid='"Username/password"' full=n file=export_name.dmp log=export_log.txt

Linux :

exp userid='"Username/password"' full=n file=export_name.dmp log=export_log.txt statistics=none


Example :

How to create a HQ dump in oracle.

Windows:

For HQ DB:

exp userid='"raymedi_hq/raymedi_hq"' full=n file=hq.dmp log=hqlog.txt

For HQ CS:

exp userid='"raymedi_cs/raymedi_hq"' full=n file=cs.dmp log=cslog.txt

For Audit :

exp userid='"raymedi_aud/raymedi_hq"' full=n file=aud.dmp log=audlog.txt


Linux :

For HQ DB:

exp userid='"raymedi_hq/raymedi_hq"' full=n file=hq.dmp log=hqlog.txt statistics=none

For HQ CS:

exp userid='"raymedi_cs/raymedi_hq"' full=n file=cs.dmp log=cslog.txt statistics=none

For Audit :

exp userid='"raymedi_aud/raymedi_hq"' full=n file=aud.dmp log=audlog.txt statistics=none

If you need more detail visit following written link : http://www.dba-oracle.com/concepts/imports_exports.htm
--------------------------------------------------------------------------------------------------------------------------

Regards,
SULTHAN-A
|Support Team|

Ph : 04353027900
Chat : www.tiny.cc\gftchat


Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB