Re: IMPORT error

Ronald wrote in message <01HW.B23ED8280015CC2901F62CF0_at_news.wxs.nl>...
>
>On Fri, 2 Oct 1998 16:38:41 +0200, mike_andrew_at_usiva.com wrote
>(in message <6v2ohh$9fv$1_at_nnrp1.dejanews.com>):
>>
>> Hello all-
>>
>> Getting a strange import error when I try to import user Oracle 7.2.3 on
>> HP/UX A.9
>>
>snip
>> . . importing table "PRIORITY_BOX" 2 rows
imported
>> . . importing table "PURCH_CARD_LOG" IMP-00009: abnormal
end
>> of export file Import terminated successfully with warnings.
>>
>> Anybody got any ideas?? Thanks in advance Mike
>>
>> -----------== Posted via Deja News, The Discussion Network ==----------
>
>> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>Did you check the log of the export ? Maybe there was an error during the
>export like 'filesystem full'.
>
>--
>Ronald
>
>---------------------------------------------------------------------------
>mailto:ronr_at_wxs.nl
>http://home.wxs.nl/~ronr/RonR.html (last update: june 8th, 1998)
>http://www.maccentral.com/news/9804/migration.shtml (forward migration
home)
>
>The best way to accelerate a machine running windows is at 9.8 m/s^2
>

We got this because when I created a database manually, I ran $ORACLE_HOME/rdbms/admin/catproc.sql as "SYS", thinking that this ran all of the other database scripts that I needed. Apparently it does not.

I also had to run the script $ORACLE_HOME/rdbms/admin/catexp.sql. After I ran this script, I no longer had the problems you describe above.

Babette Turner-Underwood
DBA / Sys Admin Received on Thu Oct 08 1998 - 14:25:41 CDT