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: IMP: still more problems

Re: IMP: still more problems

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 19 Jul 2002 20:01:23 +0200
Message-ID: <tskgjusrf6nusjhskojhoq2057mj0em6c8@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.

>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

Doesn't tell much does it? And crystall balls have sold out here.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jul 19 2002 - 13:01:23 CDT

Original text of this message

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