Re: Export tables question

Hi Gerard!
What about dropping the schemas loades or recreating the db and then make full import?
Did you read about import and 'indexfile'?

Whats wrong about doing it in more steps:

1.) imp ... rows=y constraints=n index=n [igonore=y]
2.) imp ... rows = n constraints=y index=n [ígonore=y]
3.) imp ... rows = n constraints=n index=y [igonore=y]

/Bjørn

"Gerard Lacroix" <kochel_verz_at_yahoo.com> skrev i en meddelelse news:1132854862.896072.147660_at_o13g2000cwo.googlegroups.com...
> Hi !
>
> I want to export all tables data in only one shot. I already made a
> full export with rows=n parameter, but now I need to retrieve JUST the
> data as insert into statements. I've tried many ways using pattern
> matching, but I could not success.
> For example:
> exp system/system tables=% file=exp.dmp rows=y
>
> I hope there is a better way, rather than placing user by user in the
> tables parameter:
> exp system/system file=c:\exp.dmp rows=y tables=(scott.%, oe.%,
> hr.%....)
>
> SQL> select banner from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
> PL/SQL Release 9.2.0.6.0 - Production
> CORE 9.2.0.6.0 Production
> TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
> NLSRTL Version 9.2.0.6.0 - Production
>
>
> Thanks !
>
Received on Thu Nov 24 2005 - 14:10:18 CST