OraFAQ Forum: Server Utilities » Cannot dump database backup

Home » RDBMS Server » Server Utilities » Cannot dump database backup (Oracle 8i, Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot dump database backup [message #284733]

Fri, 30 November 2007 14:01

komyg
Messages: 2
Registered: November 2007

Junior Member

Hi, I am trying to dump an .dmp file using: imp username/password file=omb.dump full=yes destroy=yes ignore=yes log=oracle.log

But the problem is that I keep getting thousands of error messages. Most of them are because when I run the script the users and tablespaces from the dump file are not created.

Here is the code for user creation in the dump file:

BEGINSYS
CREATE TABLESPACE "TBSRBS01" DATAFILE  '/omb/usr1/oradata/omb/rbdb/tbsrbs01a.dbf' SIZE 524288000 REUSE DEFAULT  STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT 
CREATE TABLESPACE "TBSUSERS01" DATAFILE  '/omb/usr1/oradata/omb/users/tbsusers01a.dbf' SIZE 1048576000 REUSE, '/omb/usr2/oradata/omb/dados/tbsusers01b.dbf' SIZE 52428800 REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 163840 ONLINE PERMANENT 
CREATE TABLESPACE "TBSOMBD160K01" DATAFILE  '/omb/usr1/oradata/omb/dados/tbsombd160k01a.dbf' SIZE 6000M REUSE, '/omb/usr3/oradata/omb/dados/tbsombd160k01i.dbf' SIZE 5000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01b.dbf' SIZE 2000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01c.dbf' SIZE 2000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01d.dbf' SIZE 2000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01e.dbf' SIZE 2000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01f.dbf' SIZE 1900M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01g.dbf' SIZE 2000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01h.dbf' SIZE 2000M REUSE, '/omb/usr3/oradata/omb/dados/tbsombd160k01j.dbf' SIZE 5000M REUSE, '/omb/usr3/oradata/omb/dados/tbsombd160k01k.dbf' SIZE 6000M REUSE, '/omb/usr2//oradata/omb/dados/tbsombd160k01l.dbf' SIZE 4000M REUSE, '/omb/usr1/oradata/omb/dados/tbsombd160k01m.dbf' SIZE 2000M REUSE, '/omb/usr5/oradata/omb/dados/tbsombd160k01n.dbf' SIZE 4000M REUSE, '/omb/usr5/oradata/omb/dados/tbsombd160k01o.dbf' SIZE 524288000 REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 163840 ONLINE PERMANENT 
CREATE TABLESPACE "TBSOMBI160K01" DATAFILE  '/omb/usr1/oradata/omb/index/tbsombi160k01a.dbf' SIZE 157286400 REUSE, '/omb/usr2/oradata/omb/index/tbsombi160k01b.dbf' SIZE 52428800 REUSE AUTOEXTEND ON NEXT 8192  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 163840 ONLINE PERMANENT 
CREATE TABLESPACE "TBSOMBD160M01" DATAFILE  '/omb/usr1/oradata/omb/dados/tbsombd160m01a.dbf' SIZE 4500M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160m01b.dbf' SIZE 1048576000 REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 167772160 ONLINE PERMANENT 
CREATE TABLESPACE "TBSOMBTESTELINUX" DATAFILE  '/omb/usr2/oradata/omb/dados/tbsombtestelinuxd01.dbf' SIZE 52428800 REUSE, '/omb/usr2/oradata/omb/dados/tbsombtestelinuxd02.dbf' SIZE 52428800 REUSE EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT 
CREATE TABLESPACE "OMB_INDEX" DATAFILE  '/omb/usr4/oradata/omb/index/omb_index02.dbf' SIZE 6000M REUSE, '/omb/usr4/oradata/omb/index/omb_index03.dbf' SIZE 4200M REUSE, '/omb/usr4/oradata/omb/index/omb_index01.dbf' SIZE 4000M REUSE AUTOEXTEND ON NEXT 8192  MAXSIZE 32767M, '/omb/usr4/oradata/omb/index/omb_index04.dbf' SIZE 3000M REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 262144 ONLINE PERMANENT 
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE  '/omb/usr4/oradata/omb/temp/temp01.dbf' SIZE 1073741824 REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 524288
CREATE TABLESPACE "OMB_DATA" DATAFILE  '/omb/usr5/oradata/omb/dados/omb_data01.dbf' SIZE 1048576000 REUSE, '/omb/usr5/oradata/omb/dados/omb_data02.dbf' SIZE 1048576000 REUSE, '/omb/usr5/oradata/omb/dados/omb_data03.dbf' SIZE 5242880 REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 262144
ALTER USER "SYS" IDENTIFIED BY VALUES '930E509073C30E89' TEMPORARY TABLESPACE "TEMP"
ALTER USER "SYSTEM" IDENTIFIED BY VALUES '75113F6A0DCF32A8' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "OUTLN" IDENTIFIED BY VALUES '4A3BA55E08595C81' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'E066D214D5421CCC' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "OMB" IDENTIFIED BY VALUES '67D000AEC7E838CD' DEFAULT TABLESPACE "TBSOMBD160K01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "HOTBACKUP" IDENTIFIED BY VALUES 'F26F51390454BCB7' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "XSAB" IDENTIFIED BY VALUES 'F4F667F4368E6790' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "COCKPIT" IDENTIFIED BY VALUES 'E488E31EF2862DC5' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "HPDBA" IDENTIFIED BY VALUES '974E0AF136F415BD' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "OMBLINUX" IDENTIFIED BY VALUES 'B797D83F1D0B2E6B' DEFAULT TABLESPACE "TBSOMBTESTELINUX" TEMPORARY TABLESPACE "TEMP"
CREATE USER "PRECISE" IDENTIFIED BY VALUES '0ADAB7C6A306D5A8' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "DBAIBI" IDENTIFIED BY VALUES '5FB35652123A04B3' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "BRAMRA" IDENTIFIED BY VALUES '62B496CDF34267F8' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "CAIORA" IDENTIFIED BY VALUES 'C4E8861A1A67773B' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "CAIORAP" IDENTIFIED BY VALUES 'F67D08AA19AAEC81' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "TIVIT" IDENTIFIED BY VALUES '7E7F71267B66E26E' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "BREPF2" IDENTIFIED BY VALUES '59D8A32E43E0D316' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "BRMGM3" IDENTIFIED BY VALUES '2B9293DC387B1061' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"
CREATE USER "PERFSTAT" IDENTIFIED BY VALUES 'AC98877DE1297365' DEFAULT TABLESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP"

A part of the error messages that follow are:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path

Warning: the objects were exported by SYSTEM, not by you

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "TBSRBS01" DATAFILE  '/omb/usr1/oradata/omb/rbdb/tbsrbs01"
 "a.dbf' SIZE 524288000 REUSE DEFAULT  STORAGE(INITIAL 40960 NEXT 40960 MINEX"
 "TENTS 1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/omb/usr1/oradata/omb/rbdb/tbsrbs01a.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "TBSUSERS01" DATAFILE  '/omb/usr1/oradata/omb/users/tbsus"
 "ers01a.dbf' SIZE 1048576000 REUSE, '/omb/usr2/oradata/omb/dados/tbsusers01b"
 ".dbf' SIZE 52428800 REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 163840 ONLI"
 "NE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/omb/usr1/oradata/omb/users/tbsusers01a.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "TBSOMBD160K01" DATAFILE  '/omb/usr1/oradata/omb/dados/tb"
 "sombd160k01a.dbf' SIZE 6000M REUSE, '/omb/usr3/oradata/omb/dados/tbsombd160"
 "k01i.dbf' SIZE 5000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01b.dbf"
 "' SIZE 2000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01c.dbf' SIZE 2"
 "000M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160k01d.dbf' SIZE 2000M REU"
 "SE, '/omb/usr2/oradata/omb/dados/tbsombd160k01e.dbf' SIZE 2000M REUSE, '/om"
 "b/usr2/oradata/omb/dados/tbsombd160k01f.dbf' SIZE 1900M REUSE, '/omb/usr2/o"
 "radata/omb/dados/tbsombd160k01g.dbf' SIZE 2000M REUSE, '/omb/usr2/oradata/o"
 "mb/dados/tbsombd160k01h.dbf' SIZE 2000M REUSE, '/omb/usr3/oradata/omb/dados"
 "/tbsombd160k01j.dbf' SIZE 5000M REUSE, '/omb/usr3/oradata/omb/dados/tbsombd"
 "160k01k.dbf' SIZE 6000M REUSE, '/omb/usr2//oradata/omb/dados/tbsombd160k01l"
 ".dbf' SIZE 4000M REUSE, '/omb/usr1/oradata/omb/dados/tbsombd160k01m.dbf' SI"
 "ZE 2000M REUSE, '/omb/usr5/oradata/omb/dados/tbsombd160k01n.dbf' SIZE 4000M"
 " REUSE, '/omb/usr5/oradata/omb/dados/tbsombd160k01o.dbf' SIZE 524288000 REU"
 "SE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 163840 ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/omb/usr1/oradata/omb/dados/tbsombd160k01a.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "TBSOMBI160K01" DATAFILE  '/omb/usr1/oradata/omb/index/tb"
 "sombi160k01a.dbf' SIZE 157286400 REUSE, '/omb/usr2/oradata/omb/index/tbsomb"
 "i160k01b.dbf' SIZE 52428800 REUSE AUTOEXTEND ON NEXT 8192  MAXSIZE 32767M E"
 "XTENT MANAGEMENT LOCAL  UNIFORM SIZE 163840 ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/omb/usr1/oradata/omb/index/tbsombi160k01a.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "TBSOMBD160M01" DATAFILE  '/omb/usr1/oradata/omb/dados/tb"
 "sombd160m01a.dbf' SIZE 4500M REUSE, '/omb/usr2/oradata/omb/dados/tbsombd160"
 "m01b.dbf' SIZE 1048576000 REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 16777"
 "2160 ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/omb/usr1/oradata/omb/dados/tbsombd160m01a.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "TBSOMBTESTELINUX" DATAFILE  '/omb/usr2/oradata/omb/dados"
 "/tbsombtestelinuxd01.dbf' SIZE 52428800 REUSE, '/omb/usr2/oradata/omb/dados"
 "/tbsombtestelinuxd02.dbf' SIZE 52428800 REUSE EXTENT MANAGEMENT LOCAL  AUTO"
 "ALLOCATE  ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/omb/usr2/oradata/omb/dados/tbsombtestelinuxd01.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "OMB_INDEX" DATAFILE  '/omb/usr4/oradata/omb/index/omb_in"
 "dex02.dbf' SIZE 6000M REUSE, '/omb/usr4/oradata/omb/index/omb_index03.dbf' "
 "SIZE 4200M REUSE, '/omb/usr4/oradata/omb/index/omb_index01.dbf' SIZE 4000M "
 "REUSE AUTOEXTEND ON NEXT 8192  MAXSIZE 32767M, '/omb/usr4/oradata/omb/index"
 "/omb_index04.dbf' SIZE 3000M REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 26"
 "2144 ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/omb/usr4/oradata/omb/index/omb_index02.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "OMB_DATA" DATAFILE  '/omb/usr5/oradata/omb/dados/omb_dat"
 "a01.dbf' SIZE 1048576000 REUSE, '/omb/usr5/oradata/omb/dados/omb_data02.dbf"
 "' SIZE 1048576000 REUSE, '/omb/usr5/oradata/omb/dados/omb_data03.dbf' SIZE "
 "5242880 REUSE EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 262144"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/omb/usr5/oradata/omb/dados/omb_data01.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 959:
 "ALTER USER "SYSTEM" IDENTIFIED BY VALUES '75113F6A0DCF32A8' DEFAULT TABLESP"
 "ACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "OMB" IDENTIFIED BY VALUES '67D000AEC7E838CD' DEFAULT TABLESPAC"
 "E "TBSOMBD160K01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSOMBD160K01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "HOTBACKUP" IDENTIFIED BY VALUES 'F26F51390454BCB7' DEFAULT TAB"
 "LESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "XSAB" IDENTIFIED BY VALUES 'F4F667F4368E6790' DEFAULT TABLESPA"
 "CE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "COCKPIT" IDENTIFIED BY VALUES 'E488E31EF2862DC5' DEFAULT TABLE"
 "SPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "HPDBA" IDENTIFIED BY VALUES '974E0AF136F415BD' DEFAULT TABLESP"
 "ACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "OMBLINUX" IDENTIFIED BY VALUES 'B797D83F1D0B2E6B' DEFAULT TABL"
 "ESPACE "TBSOMBTESTELINUX" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSOMBTESTELINUX' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "PRECISE" IDENTIFIED BY VALUES '0ADAB7C6A306D5A8' DEFAULT TABLE"
 "SPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "DBAIBI" IDENTIFIED BY VALUES '5FB35652123A04B3' DEFAULT TABLES"
 "PACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "BRAMRA" IDENTIFIED BY VALUES '62B496CDF34267F8' DEFAULT TABLES"
 "PACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "CAIORA" IDENTIFIED BY VALUES 'C4E8861A1A67773B' DEFAULT TABLES"
 "PACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "CAIORAP" IDENTIFIED BY VALUES 'F67D08AA19AAEC81' DEFAULT TABLE"
 "SPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "TIVIT" IDENTIFIED BY VALUES '7E7F71267B66E26E' DEFAULT TABLESP"
 "ACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "BREPF2" IDENTIFIED BY VALUES '59D8A32E43E0D316' DEFAULT TABLES"
 "PACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "BRMGM3" IDENTIFIED BY VALUES '2B9293DC387B1061' DEFAULT TABLES"
 "PACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
 "CREATE USER "PERFSTAT" IDENTIFIED BY VALUES 'AC98877DE1297365' DEFAULT TABL"
 "ESPACE "TBSUSERS01" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TBSUSERS01' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE SESSION TO "OMB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OMB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE TABLE TO "OMB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OMB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE SEQUENCE TO "OMB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OMB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE PROCEDURE TO "OMB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OMB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE SYNONYM TO "OMB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OMB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE PUBLIC SYNONYM TO "OMB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OMB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT ALTER SYSTEM TO "HOTBACKUP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HOTBACKUP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT ALTER TABLESPACE TO "HOTBACKUP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HOTBACKUP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT ALTER DATABASE TO "HOTBACKUP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HOTBACKUP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE SESSION TO "XSAB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'XSAB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE TABLE TO "COCKPIT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'COCKPIT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE PROCEDURE TO "COCKPIT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'COCKPIT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT UNLIMITED TABLESPACE TO "OMBLINUX""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OMBLINUX' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT CREATE SESSION TO "COCKPIT""

As you can see the path to create the tablespaces are written for Linux and not for Windows. I've tryed to change those manually but then I get another error message:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

What should I do?

Thank you,
Komyg

Report message to a moderator

Re: Cannot dump database backup [message #284743 is a reply to message #284733]

Fri, 30 November 2007 15:01

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

What should I do?

You could post larger lines.

What about previoulsy create the tablespace with the datafiles you want?

Regards
Michel

Report message to a moderator

Re: Cannot dump database backup [message #284860 is a reply to message #284733]

Sat, 01 December 2007 22:49

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Check the path, like

path /omb/usr1/oradata/omb/rbdb/ exists or not ! and oracle have permission on the intended path .

Report message to a moderator

Re: Cannot dump database backup [message #284867 is a reply to message #284860]

Sun, 02 December 2007 00:46

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Obviously it can't exist on Windows.

Regards
Michel

Report message to a moderator

Re: Cannot dump database backup [message #285153 is a reply to message #284867]

Mon, 03 December 2007 14:34

komyg
Messages: 2
Registered: November 2007

Junior Member

Michel, you were correct if I create the tablespaces manually before I dump the database contents I can specify a proper Windows path instead of a Linux one.

I did this and all worked fine.

Thanks again,
Komyg

Report message to a moderator

Previous Topic:	load xml file/data in oracle table through sql*loader
Next Topic:	How to use imp.exe

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 23:56:09 CST 2024