Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help on partition managing

Re: Help on partition managing

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 23 Jul 2002 11:13:05 +1000
Message-ID: <wZ1%8.41552$Hj3.124294@newsfeeds.bigpond.com>


Hi Roger,

If you know what you're going when editing the export file and corrupting it is not overly of concern then hey, it's a free world.

However, logging the import with show=y or creating the indexfile is a far "safer" and supported method of accomplishing the same thing.

Cheers

Richard
"Enkidu" <utnapishtim43NOSPAM_at_hotmail.com> wrote in message news:qZT_8.15218$Fq6.1464863_at_news2.west.cox.net...
> Joe,
> This technique used to be quite common back in the Oracle6 days (just
like
> editing the Forms3 .inp files with vi used to be). Although Oracle raises
> its corporate eyebrow at anyone who attempts to edit one of their files,
> people will continue to do it until Oracle releases tools that have
features
> like global search/replace.
>
> May I make a suggestion. I assume that since you have an export file.
you
> also have access to the source database (unless you're receiving the
export
> file from a 3rd party). If you do have access to the source database, it's
> far easier to build a dynamic sql script that uses the DBA_% views to
> generate scripts to rebuild objects on your target database. If you're
> receiving the export file from someone else and don't have access to the
> source database, then vi is as good as anything else. The database I'm
> currently the DBA for doesn't use partitioned tables (I have a dream DBA
> job), so I can't test it out for you ... but perhaps you have to find and
> eliminate other lines in the dump file for partitioned tables to work.
It's
> been quite a while since I "played" with export dump files, but we used to
> also type a Unix command like "strings export_file.dmp" to get an overall
> picture of what the file contained.
>
> Roger Crowley - DBA - LearningFramework
>
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:WHw_8.40367$Hj3.120305_at_newsfeeds.bigpond.com...
> > Hi Joe,
> >
> > Not sure what your problem is ?
> >
> > If you export a partitioned table, the export file *will* (or perhaps
> should
> > in your case) contain the definition of the partitioned table. Are you
> sure
> > you are using the 8.1.7 version of EXP to perform the export ?
> >
> > I must say the fact you vi the export file kinda sends a shiver up my
> spine.
> > You should *never* edit this file (or you will suffer the consequences
my
> > boy as my old headmaster used to say). May I suggest either an import
with
> > show=y or an import with indexfile=filename to see exactly what is
defined
> > for this table of yours. I say again, don't play around with the actual
> > export file.
> >
> > Good Luck
> >
> > Richard
> > "Joe Bayer" <u705413818_at_spawnkill.ip-mobilphone.net> wrote in message
> > news:l.1027098326.1057342529@[64.94.198.252]...
> > > Hi, we are using oracle 8172
> > >
> > > I used to use export with rows=n to get the dump file, and vi the dump
> > > file, after delete the first few lines, we can get the table re-create
> > > script.
> > >
> > > But if the table is partitioned, when I open the dump file with vi, I
> > > can not see any table re-create script even if I deleted all the
lines,
> > > is there any way I can get the ddl of a table?
> > >
> > > When we user create table bla as select * from table A, what I got is
> > > unpartitioned tables, is there any convinent way to create a copy of a
> > > partitioned, sub-partitioned table?
> > >
> > >
> > > Thanks for your help
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Sent by joebayerii from hotmail within area com
> > > This is a spam protected message. Please answer with reference header.
> > > Posted via http://www.usenet-replayer.com/cgi/content/new
> >
> >
>
>
Received on Mon Jul 22 2002 - 20:13:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US