Importing only views DDL while importing Schema

#1

Hi guys....

All i want to know is
if while importing schema
i just want to import the ddl of my views nothing else ( no change in
Data and definition of my table)
then how should i import the schema
Waiting for the reply..

Cheers
Faizee

#2

<Faizanamjad (AT) gmail (DOT) com> a écrit dans le message de news: 1153111397.909906.128430 (AT) s13g20...oglegroups.com...

Quote:

Hi guys....

All i want to know is
if while importing schema
i just want to import the ddl of my views nothing else ( no change in
Data and definition of my table)
then how should i import the schema
Waiting for the reply..

Cheers
Faizee

Export view DDL with DBMS_METADAT.
With export/import you can't do that but you can do it with Data Pump.

Regards
Michel Cadot

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Importing only views DDL while importing Schema

comp.databases.oracle.misc comp.databases.oracle.misc

Importing only views DDL while importing Schema - 07-16-2006 , 11:43 PM

Re: Importing only views DDL while importing Schema - 07-17-2006 , 11:13 AM