Re: Importing a view ??

From: Ronald <ronr_at_wxs.nl>
Date: Tue, 19 Jan 1999 20:45:54 +0100
Message-ID: <01HW.B2CA9F82000657E4126CD1E0@news.wxs.nl>

On Tue, 19 Jan 1999 17:04:49 +0100, Ken Chow wrote (in message <782a31$na15_at_news.asiaonline.net>):
>
> I want to know also. I think the workaround here is to extract all the
> object definition by using the import with show option and then cut that
> particular view creation statement.
>
> Ken Chow
>
> philippe BACKOUCHE wrote in message <7828jb$se7$1_at_news.imaginet.fr>...

>> Dear Oracle DBA's, 
>> 
>> I have a simple dumb question... How can I import a given view or 
>> procedure from an import file without importing the whole stuff ?? 
>> 
>> Best Regards, 
>> 
>> Philippe BACKOUCHE 
>> 
>> 

>
>

Just use 'grep "CREATE VIEW your_view" expdat.dmp >view.sql' This creates a create view sql file.

--

Ronald  -  Unix SA               http://home.wxs.nl/~ronr/professional.html

        -  Oracle DBA            http://www.tresco.nl  
        -  Middleware programmer/
                      designer   mailto:R.Rood_at_tresco.nl
 

Received on Tue Jan 19 1999 - 13:45:54 CST