Import Problems with Oracle 8i - please help..Backup/restore or export/ import ???
Date: 10 Mar 2003 07:19:16 -0800
Message-ID: <25c1993e.0303100719.7192d191_at_posting.google.com>
Dear Oracle gurus,
I have 2 database servers one running 8.1.7 Standard Edition and the
second one 8.1.7 Enterprise edition.
Import file: expdat.dmp > expdat.dmp
I get tons of errors. I will just mention a few with the error codes
IMP-00015: following statement failed because the object already
exists(lots of these)
Observed that IMP-00003 always occured after IMP-00017
Importing views failed with compilation warnings and error code
IMP-00015
What should I be doing now. Looks like it is tedious recitifying these
errors
My goal is like this.
(Acutally the second one was Standard too and I upgraded to
Enterprise by de-installing the SE software and installing new one.)
I created a brand new databse on the Server running EE edition using
dbassist
I exported the database from the Server running SE edition as
sys/change_on_install and chose the option 1 Entire Database
Now I tried importing this expdat.dmp file into the server running EE
edition again as sys/change_on_install (Attempted to import the entire
DB again )
These were the following options chosen when importing
Enter insert buffer size( minimum is 8192) 30720 >
Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR charatcer set
List contents of import file only (yes/no): no >
Ignore create error due to object existence (yes/no): no >
Import grants (yes/no): yes >
Import table data( yes/no): yes >
Import entire export file ( yes/no): no > yes
IMP-00017:following statement failed with ORACLE error 1917 (lots of
these)
IMP-00003: ORACLE error 1917 encountered
Your help will be greatly appreciated
-thx,
avsrk
Received on Mon Mar 10 2003 - 16:19:16 CET