Re: Exporting with parfile

Then what parameter can I add to that so I can export stored procs, (and other things like synonms, etc).

What I really want is to export everything under the user except one stinkin table (which has a blob in it). I don't care if I have to write a parfile which lists every single object (from the table all_objects)

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tpqdvi8m3u7j0f_at_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 - 22:16:29 CDT