And a packet of Jaffa Cakes... then you're on!
Regards
HJR
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:Ntd_8.39452$Hj3.119275_at_newsfeeds.bigpond.com...
> Hi Howard,
>
> Not so sure.
>
> I think the days of having Export/Import as a backup/recovery strategy are
> definitely gone (not that I really think those days were really there). I
> think the incremental/cumulative components were always somewhat dubious
in
> that they apply at the object level (whereas RMAN has always been at the
> block level - way way more useful). There have also been quite significant
> improvements with these utilities over the last few releases
(transportable
> tablespaces, tablespace level exports, filesize and multiple files,
> flashback, resumable, query option (really nice) and I'm sure others).
>
> So I think they here to stay BUT to be used for what they're are designed,
> which is not to backup and protect the database.
>
> Let's keep these postings for 5 years and see who's right. 10 bucks ?
>
> Richard
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:ahbb1k$476$1_at_lust.ihug.co.nz...
> > Just my tuppence-worth.
> >
> > Oracle is on record as saying that cumulative/incremental exports will
be
> > de-supported in the future, and (from memory only) the reason they gave
> was
> > that RMAN is the cumulative/incremental guru in these parts.
> >
> > This is just my wild speculation (usual disclaimers apply) but I don't
> > honestly see much of a future for export and import. You've got
> > dbms_metadata in 9i for the structural components. You've got logminer
for
> > transactional replay. You've got other things besides... strikes me that
> the
> > days of export/import are distinctly numbered.
> >
> > And it wouldn't surprise me in the least if one of the factors in that
> > turned out to be exactly what you're saying: so much is happening in the
> > database that it gets harder and harder to update export/import to keep
> up.
> >
> > Regards
> > HJR
> >
> >
> > "Chuck" <chuckh_at_softhome.net> wrote in message
> > news:ah9nug$rb5fg$1_at_ID-85580.news.dfncis.de...
> > >
> > > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > > news:tskgjusrf6nusjhskojhoq2057mj0em6c8_at_4ax.com...
> > > > On Fri, 19 Jul 2002 11:34:57 -0400, "Chuck" <chuckh_at_softhome.net>
> > > > wrote:
> > > >
> > > > >I am encountering even *more* problems with the 8.1.7 import
utility
> on
> > > AIX.
> > > > >Am I doing something wrong or is this utility just a piece of cr*p?
> > > > >
> > > > >Latest issue. I am trying to use a norows full export to create
> > indexes,
> > > > >primary keys, constraints, grants etc. on a database that I copied
> from
> > > > >another platform using CTAS on every table. (I used CTAS to load
the
> > > data
> > > > >because import was too slow. It took 70+ hours whereas CTAS took
> about
> > > 3.)
> > > > >The create index and alter statements are in the export file to
> create
> > > the
> > > > >unique indexes for the PKs, then alter them to PK constraints. I
can
> > grep
> > > > >them out of the file with no problem. The import however never even
> > tries
> > > to
> > > > >apply them. There are no errors in the log file indicating that it
> > failed
> > > to
> > > > >apply them for any reason. It just ignores them. It also ignores
all
> of
> > > my
> > > > >FK constraints.
> > > > >
> > > > >Before I open a tar with oracle, is this expected behavior for
> EXP/IMP?
> > > Am I
> > > > >forgetting something?
> > > > >
> > > > >Here is the command I am using to run the export and the import.
The
> > last
> > > > >line of the export log file says it finished with no warnings.
> > > > >
> > > > >exp user/pass file=norows full=y rows=n log=norows_export.log
> > > > >imp user/pass file=norows full=y log=norows_import.log
> > > > >
> > > > >
> > > >
> > > > >I am encountering even *more* problems with the 8.1.7 import
utility
> on
> > > AIX.
> > > > >Am I doing something wrong or is this utility just a piece of cr*p?
> > > >
> > > > Millions of people can use it.
> > >
> > >
> > > I used to be one of them - from version 7.0 to 8.1. But I keep finding
> > more
> > > and more problems with a tool that used to work well. As features were
> > added
> > > to the RDBMS, imp/exp just hasn't kept up. Wrong sizes exported for
> > > datafiles, grants that are not exported, etc. I would warn anyone who
is
> > > depending on it as a backup/restore method to reconsider. The most
basic
> > > function of a backup/restore solution is to backup data and restore it
> to
> > > the same logical state as when it was backed up. EXP/IMP does not do
> > that -
> > > period. Is it any wonder Oracle keeps losing market share?
> > >
> > >
> >
> >
>
>
Received on Sat Jul 20 2002 - 09:01:18 CDT
