Export tables question

From: Gerard Lacroix <kochel_verz_at_yahoo.com>
Date: 24 Nov 2005 09:54:23 -0800
Message-ID: <1132854862.896072.147660@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 - 11:54:23 CST