Importing only views DDL while importing Schema

Faizanamjad@gmail.com · *nix forums beginner Joined: 17 Jul 2006 Posts: 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

Michel Cadot · *nix forums Guru Joined: 24 Apr 2005 Posts: 457

<Faizanamjad@gmail.com> a écrit dans le message de news: 1153111397.909906.128430@s13g2000cwa.googlegroups.com...
| 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

Google