| imp query [message #173222] |
Sat, 20 May 2006 07:02  |
shivnagpal
Messages: 5
Registered: May 2006
Location: DELHI
|
Junior Member |
|
|
hello
i have a exported data of oracle
i want to import from it a table and only half of its rows like if in this table 30000 rows then i wnat to import only 15000 rows.
can this be possible
if yes then plz tell me the import command for this
thanks
|
|
|
|
|
|
| Re: imp query [message #173372 is a reply to message #173225] |
Mon, 22 May 2006 02:48  |
shivnagpal
Messages: 5
Registered: May 2006
Location: DELHI
|
Junior Member |
|
|
thanks for your help
but the problem is database exporting succesfully
but at the time of import error occur
IMP-00058: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
IMP-00028: partial import of previous table rolled back: 25580 rows rolled back
i had checked all the things that any row inserted with large precision than the defined, but this is not the case.
i had recoverd the database through oracle recovery. all the reovers succesfully then i imp the recovered database and now data importing succesfully
but i can't understand why the above error occur
others told me that due to data corruption this error had occured
if reason is something else, then plz tell me
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
