Re: Help on partition managing

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 - 08:42:46 CDT