Exporting with parfile

From: Luch <luciano_at_nospam.com>
Date: Mon, 10 Sep 2001 19:34:06 GMT
Message-ID: <OA8n7.12036$d86.923018@newsread1.prod.itd.earthlink.net>

Hello all,

I'd like to have a batch file that exports an entire schema/user (ODB) except a table which has a BLOB field in it. I did the following parfile:

USERID=ODB/ODB_at_tns:trax
FILE=odb_OM_2001_09-10.dmp
GRANTS=y
ROWS=y
COMPRESS=n
CONSTRAINTS=y
INDEXES=y
TRIGGERS=y
RECORDLENGTH=8192 TABLES=(AC_ACTUAL_FLIGHTS)
TABLES=(AC_ACTUAL_FLIGHTS_CREW_MEMBER)
etc...

The problem is that it doesn't export things other than tables, such as stored procs and such. In other words, I want a way to export EVERYTHING under the user ODB except one table (which I'll omit from the tables= list).

--
Luciano Belotto
replace nospam with traxsoftware for e-mail

Received on Mon Sep 10 2001 - 14:34:06 CDT