Re: Import Problems with Oracle 8i - please help..Backup/restore or export/ import ???

Hi there,
Its me again. I tried exporting as system/manager and again importing likewise as mentioned in u r mail and with options ignore=y and commit=y. It dint help. I had lots of error messages. Any clue.

-thx,
avsrk

Svend Jensen <oraclecare_at_netscape.net> wrote in message news:<3E6CE016.800_at_netscape.net>...
> First,,, you are not supposed to import user SYS. :-)
>
> The standard way is to export full database as system.
> And import it likewise with ignore=y and commit=y and ......
> It is better to create a parameter file to be able to use all options.
> Try exp help=y and imp help=y. Or read the docs.
> Beware of the large buffer bug. Se Metalink.
>
> Rgds
> /Svend
>
>
> Subrahmanyam Arya wrote:
> > Dear Oracle gurus,
> >
> > I have 2 database servers one running 8.1.7 Standard Edition and the
> > second one 8.1.7 Enterprise edition.
> > (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
> >
> > Import file: expdat.dmp > expdat.dmp
> > 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
> >
> > 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)
> > IMP-00017:following statement failed with ORACLE error 1917 (lots of
> > these)
> > IMP-00003: ORACLE error 1917 encountered
> >
> > 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.
> >
> > 1] Customers are running SE edition. We need to upgrade them to EE
> > with out much hassles. So their scenario is little difft in the sense
> > only machine is there and it needs to go from SE to EE with out data
> > loss
> > 2] So what are the options we recommend for them.
> > 3] Export the database. De-install standard. Install EE and import it
> > back ??? all on one and the same machine.
> > 4] What is the difference if they were to backup as opposed to export
> > and later restore instead of importing. Which one should we recommend
> > Export/Import or backup/Restore??? The customers any way need to go
> > offline /shutdown the DB for upgrade
> >
> > 5] Am I seeing these errors on my test bed becuase i am uisng 2 difft
> > servers ?? Is it because i am exporting Dataabse from the server
> > running Standard edition and becuase, i am importing the same database
> > on a different machine after creating a brand new one ????
> >
> > Your help will be greatly appreciated
> > -thx,
> > avsrk
Received on Tue Mar 11 2003 - 00:03:07 CET