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

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

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP