Exporting Tables That Begins With A Particular Letter

[engiri]

WE WANT EXPORT TABLES THAT START WITH A PARTICULAR LETTER.
THAT IS WE WANT TO GIVE CONDITION AT THE TIME OF EXPORT LIKE TABLES = 'P%'
IS IT POSSIBLE..

[hrishy]

Hi

Nope

what you can do is this

select ''''|| table_name ||''''||',' from user_tables
where table_name like 'P%'


then copy paste the output to the tables parameter in export parameter file..

regards
Hrishy

[engiri]

I got it

exp user/password file=d:\x.dmp tables=a%

it worked..in 9i. this option is not there in 8.