Hi,
I am using following query cmd script to take Export and Import
Expdp
------
expdp SYSTEM/PW@Instance_name FULL=y DIRECTORY=dir_name DUMPFILE=xyz.dmp LOGFILE=xyz.log JOB_NAME=myfullJob
Impdp
-----
impdp SYSTEM/pw@Instance_name full=Y directory=dir_name dumpfile=xyz.DMP logfile=xyz.log JOB_NAME=myfullJob
I need clarity on below,
1) Is it possible to export Views from database.
2) If Possible then Above mentioned impdp / Expdp can achieve it. if not then please share cmd script to achieve to do Export and Import with all Views.
3)
Example
-------------
DATABASE NAME :AUDITSDB
INSTANCE NAME : AUDITSDBINS
TNSNAME ALIAS ENTRY FOR ABOVE INSTANCE: AUDITSDBTNS
I used a comment in the cmd script as SYSTEM/PW@Instance_name,
Some time if i give instance name then it is not start export thrown error and then if i give tnsname.ora alias name for instance export can start. Is there any rules is there when to give instance or tnsname alias name at the time export.
Please suggest me. Thanks in Advance.