 Error of Import [Full=Y] [message #404439] |
Thu, 21 May 2009 19:12  |
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 #404453 is a reply to message #404447] |
Thu, 21 May 2009 20:06  |
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.
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
