Error while using IMP [message #299670] |
Tue, 12 February 2008 23:07 |
it_me24
Messages: 167 Registered: March 2006 Location: delhi
|
Senior Member |
|
|
HI All,
I am facing an issu while using import.
please help in solving the problem.
Import statement:
imp asdwlbdb/asdwlbdb file=/home/june/intapdata2/unidb_nov07/as/dump/asdwlbdb_ac_081207_21:05:00.dmp
log=/home/june/impas.log
tables=AC_PREPAID_UPLOAD:SEP07
fromuser=asdwlbdb
touser=asdwlbdb
constraints=y
grants=y
ignor=y
buffer=104857600
while running the Imp command i get the following error.
Export file created by EXPORT:V10.01.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully
Please advice in solving the isssue.
thanks in advance.
|
|
|
Re: Error while using IMP [message #299675 is a reply to message #299670] |
Tue, 12 February 2008 23:23 |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
it_me24 wrote on Wed, 13 February 2008 12:07 | HI All,
I am facing an issu while using import.
please help in solving the problem.
Import statement:
imp asdwlbdb/asdwlbdb file=/home/june/intapdata2/unidb_nov07/as/dump/asdwlbdb_ac_081207_21:05:00.dmp
log=/home/june/impas.log
tables=AC_PREPAID_UPLOAD:SEP07
fromuser=asdwlbdb
touser=asdwlbdb
constraints=y
grants=y
ignor=y
buffer=104857600
|
Are you sure about the user who exported this file is ASDWLBDB?
Quote: |
while running the Imp command i get the following error.
.............................................................
Export file created by EXPORT:V10.01.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully
Please advice in solving the isssue.
|
Use Full=Y to import instead of FromUser/ToUser. By default, these parameter Tables, Indexes, Constraints are set to Y (Yes), so that, you do not need to give it in your command.
[Updated on: Tue, 12 February 2008 23:24] Report message to a moderator
|
|
|
Re: Error while using IMP [message #299678 is a reply to message #299670] |
Tue, 12 February 2008 23:28 |
it_me24
Messages: 167 Registered: March 2006 Location: delhi
|
Senior Member |
|
|
Hi,
I modified the command below.
imp asdwlbdb/asdwlbdb file=/home/june/intapdata2/unidb_nov07/as/dump/asdwlbdb_ac_081207_21:05:00.dmp
log=/home/june/impas.log
tables=AC_PREPAID_UPLOAD:SEP07
FULL=Y
constraints=y
grants=y
ignor=y
buffer=104857600
but still the error comes as below.
Export file created by EXPORT:V10.01.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully
please suggest, it is very urgent.
thanks again
|
|
|
|
|
|
Re: Error while using IMP [message #299713 is a reply to message #299670] |
Wed, 13 February 2008 00:23 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
I hope the missing "e" is not causing any error.
Do it this way:
imp asdwlbdb/asdwlbdb file=/home/june/intapdata2/unidb_nov07/as
/dump/asdwlbdb_ac_081207_21:05:00.dmp
log=/home/june/impas.log
tables=AC_PREPAID_UPLOAD:SEP07
constraints=y
grants=y
ignore=y
buffer=104857600
It will prompt for the username,give asdwlbdb
[Updated on: Wed, 13 February 2008 00:24] Report message to a moderator
|
|
|
|