Re: IMP: still more problems

Hi Chuck,

Lets be perfectly clear about this. EXP/IMP is not a "backup/restore solution" !! It takes logical copies of components of your database, nothing more, nothing less. It has many uses but a "backup/restore solution" is *NOT* one of them. Never has been.

You need to take a *physical* backup of the database, you have to have all the *redo logs* since your backup to have a "backup/restore solution".

Quite, 100%, totally and utterly, different kettle of fishbits (thanks Howard) functionality between the two.

Regards

Richard

"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 Fri Jul 19 2002 - 19:44:06 CDT