Re: Exporting with parfile

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 10 Sep 2001 23:56:01 +0200
Message-ID: <tpqdvi8m3u7j0f@news.demon.nl>

"Luch" <luciano_at_nospam.com> wrote in message news:OA8n7.12036$d86.923018_at_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
>
>

A table export doesn't export stored procedures. That's the way it works.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Mon Sep 10 2001 - 16:56:01 CDT