Home » RDBMS Server » Server Utilities » IMP (Is it possible without do it without warrning.)
IMP [message #339916] Sat, 09 August 2008 13:11 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member


ORACLE 9.2 Red Hate Linux 4.5 ES

Phase -I
I created new database. & ran catalog & catproc script.

shutdown normal database.

Took full backup thru OS.

---------------------------------------

Phase - II

started database create new tablespace & table in that.

Did full database export.

EXP userid=system/manager full=y file=export.dmp

Successful without warnings.

shutdown database

----------------------------------------------------

Phase - III

Deleted whole database.

Restore all backup file of newly created database.

Did import

imp userid=system/manager file=export.dmp ignore=y full=y

Completed successfully but with warning.


How to avoid that warnings.

Or is it simply impossible to import full database without warnings.

Re: IMP [message #339918 is a reply to message #339916] Sat, 09 August 2008 13:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Or is it simply impossible to import full database without warnings
Unless you are going to post the session log, it is impossible to guess reason for warnings.
Usually warning are not fatal.
May be it is because you are importing with ignore=y, the errors occurred during import (because of existing objects) are ignored, but still generate warnings.
Re: IMP [message #339920 is a reply to message #339916] Sat, 09 August 2008 13:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Or is it simply impossible to import full database without warnings.

Avoid the situation that raise warnings.

And exp/imp are NOT backup.

Regards
Michel
Re: IMP [message #339921 is a reply to message #339918] Sat, 09 August 2008 13:56 Go to previous message
IT Guru
Messages: 59
Registered: January 2007
Member
sorry for not posting log.

As it happen in office.

Will recreate scenario & post errors.

But mostly it came as it tried to create/update system tables.

& as far as I know export does not include sys schema.


---------------------------------------------------------------



If import full= y for dump which also include tablespace

Is this create tablespace automatically [ at db_create_file_dest] or we have to create manually.

I tried but did not work. gave error in creating tablespace datafile as directory structure was different.
Previous Topic: export a single row
Next Topic: question about access & oracle
Goto Forum:
  


Current Time: Sun Dec 04 20:25:33 CST 2016

Total time taken to generate the page: 0.09397 seconds