Hi,
I need to export some views. I tried using expdp for exporting, but I am getting some errors.
I am getting the below error:
ORA-39168: Object path VIEW was not found.
ORA-31655: no data or metadata objects selected for job
Job "IM"."SYS_EXPORT_SCHEMA_01" completed with 2 error(s) at 16:31:12
Commad used is:
expdp <username>/<password> PARFILE=IM_VIEWS.par
ParameterFile:
DIRECTORY=Dpump_IMdir1
DUMPFILE=IM_VIEWS.dmp
CONTENT=ALL
INCLUDE=VIEW:"='View_PD_ShoppingCart'"
Can anyone please let me know whether exporting view using expdp is possible or not?
If yes, please let me know as to where i have gone wrong.
Please suggest as to how to export the views in 10g.
Any help would be much appreciated.
Thanks,
Ramya