Home » RDBMS Server » Server Utilities » Error of Import [Full=Y] (Solaris 9; Oracle 9i;)
icon3.gif  Error of Import [Full=Y] [message #404439] Thu, 21 May 2009 19:12 Go to next message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
Hi guys,

I have problem with import process.

I'm creating test database same as production using existing database.
I got the backup using exp tool. There is no error.

# exp parfile=full.par

full.par files content:
userid=system
Full=y

Now, I'm trying to do the full import using following import_full.par file:

userid=system/password
file=full.dmp
log=Restore_Full.log
FULL=y
DESTROY=y
indexes=y
CONSTRAINTS=y
GRANTS=Y
ROWS=Y
commit=y
ignore=y

# imp parfile=import_full.par

When I executed it, following error messages came.

IMP-00017: following statement failed with ORACLE error 28007:
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'D5303D4DEC6A51EA' TEMPORARY TABLE"
"SPACE "TEMP""
IMP-00003: ORACLE error 28007 encountered
ORA-28007: the password cannot be reused

IMP-00017: following statement failed with ORACLE error 23327:

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (USER1.SYS_C0025925) violated
Column 1 CUSI
Column 2 05-FEB-2007:00:00:00
Column 3 77140760000
Column 4 5A71
Column 5 I
Column 6 0
Column 7 B
Column 8 ACP
Column 9 201011100
Column 10 200702
Column 11 05-FEB-2007:00:00:00
Column 12 77140760000
Column 13 -71.1
Column 14 0
Column 15 0
Column 16 05-FEB-2007:00:00:00
Column 17 212540
Column 18 CG066463
Column 19 USD
Column 20 CUSI20070205771406400005A71I
Column 21 000438#000000008
Column 22
Column 23
Column 24
Column 25
Column 26
Column 27 CG066463
Column 28
Column 29
Column 30
Column 31
Column 32
Column 33
Column 34
Column 35
Column 36
Column 37
Column 38
Column 39 000438

Is it okay?
I enabled "DESTROY=Y". Therefore Import process overwrites the all data. But many error messages came and I confused.

How do I import full data to existing, working database?

Thank you,
Erdenejargal.B
Re: Error of Import [Full=Y] [message #404447 is a reply to message #404439] Thu, 21 May 2009 19:35 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>I'm creating test database same as production using existing database.
There are easier/better/faster ways to "clone" DB than exp/imp.
One, for example, is cold backup & restore.
Re: Error of Import [Full=Y] [message #404453 is a reply to message #404447] Thu, 21 May 2009 20:06 Go to previous message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
I see,
I will try it.

BlackSwan wrote on Thu, 21 May 2009 19:35
>I'm creating test database same as production using existing database.
There are easier/better/faster ways to "clone" DB than exp/imp.
One, for example, is cold backup & restore.

Previous Topic: Privilege issue when running impdp with transportable tablespace
Next Topic: stored procedure for creating a new schema from an old one
Goto Forum:
  


Current Time: Sat Dec 03 04:06:57 CST 2016

Total time taken to generate the page: 0.13818 seconds