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

Tagged:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.