| Import only a view [message #71161] |
Wed, 18 September 2002 00:42  |
Paulo M R Correia
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
I've deleted a view and now I want to restore it from a dump file.
But when i'm importing, i only can select a table or a partition.
Does anyone know how i can do this 'restore' ?
thanks in advance.
Paulo
|
|
|
|
| Re: Import only a view [message #71209 is a reply to message #71161] |
Tue, 24 September 2002 11:28  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Import allows you to create a text file from the export file.
imp system/manager full=y show=y rows=n log=yourtextfile file=expdat.dmp
If you have a unix OS:
strings expdat.dmp > yourtextfile
Once you have the file you can cut and paste into a sql script and run it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
