I want to import another DB which was exported as a user.
So I import it as a user, choose the path of the import (direct to CD-ROM) and the logfile. Then I continue with default settings. I see that a job is created which fails quickly. I want to know why it failed, no logfile was created.
I am using Oracle 9i. Find the settings of the import below
Importobjekte: Von Benutzer(n): tcmdbuser
Verknüpfte Objekte: Mit Datenbankobjekten verknüpfte Berechtigungen , Indizes auf Tabellen, Zeilen mit Tabellendaten, Constraints auf Tabellen
nice idea, Littlefoot! I"ll let you know the results when I am back at the oracle server.
Other ideas also welcome! I talked now to the Oracle-Admin who gave me the dump. He has no experience with Oracle under windows, he made the dump with Linux. He said it should be pretty straight forward. Just create a user / node. Tell the import the location of the dump and the logfile and that's it. I was wondering why no log was created. The job was forwarded, started and failed quickly without showing errors
If that happens again, check whether the Database Instance is up and Running or not.
Also you could even look at the ORACLE_SID that is set in the environment before starting the import. some times it may happen that the SID is different and the Database SID in the .DMP file is different and so it may fail.
Check this and just post the message the IMPORT utility shows when invoked.
Well, large export/import operations rarely go without *any* problems; usually it is about grants to users that do not exist on your new system (but existed on system where you took the export file), views' create statements fail and such things; furthermore, problems can be encountered when NLS settings do not match, etc. But, generally speaking, it *should* be OK. More or less.