Posts

Showing posts from August, 2009

Importing just 1 view via impdp

Hi,
Struggling the right syntax in Unix environment for importing a lost view, here is the proper way:
impdp user/password@database directory=dir_dump dumpfile=dump.dmp logfile=imp_MY_VIEW.log INCLUDE=VIEW:\"= \'MY_VIEW\'\" job_name=imp_MY_VIEW