Question: How do I import a single view in
Oracle? I tried using imp in my dmp file but
failed. How do I import a view in import?
Answer: You can use the data pump
impdp utility to import all views:
scott/tiger . . . include=views
Here we use import to import a specific view using the