IMP [message #339916] |
Sat, 09 August 2008 13:11 |
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 #339921 is a reply to message #339918] |
Sat, 09 August 2008 13:56 |
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.
|
|
|