Monday, August 24, 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

3 comments:

Peter said...

try this

impdp user/password@database directory=dir_dump dumpfile=dump.dmp logfile=imp_MY_VIEW.log INCLUDE=VIEW:\"= \'MY_VIEW\'\" job_name=imp_MY_VIEW schemas=my_schemas

Saulo Ferreira said...

Ajudou d+. funciona muito bem!

Yossi Nixon said...

If my_schema is different from the user, your way is necessary.
Thanks