Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting with parfile
Did you read my answer at all?
You *CAN"T* export procedures in table mode. PERIOD!!!!!!!!!!!!
Use TOAD or something else to dump them.
Regards,
Sybrand Bakker, Senior Oracle DBA
"Luch" <optimaljedi_at_nospam.net> wrote in message
news:hmfn7.12839$d86.1003265_at_newsread1.prod.itd.earthlink.net...
> 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 - 23:36:00 CDT
![]() |
![]() |