-
Import Error
While importing i am getting the following errors.
IMP-00017: following statement failed with ORACLE error 604:
"COMMENT ON COLUMN "IP_USER_ROLE_MAST"."USER_ROLE_DESC" IS 'This column is "
"used store the description of role'"
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-01401: inserted value too large for column
ORA-06512: at line 2
Why i am getting the error and how to avoid it.
Regards
Pradipta
-
From the error message it seems that the table into which you are importing has diff column length (smaller) than the table from which data was exported.
Increase the size of the table column...
More details would have been helpful....
Amar
"There is a difference between knowing the path and walking the path."
-
It's posts like this that really piss me off.
1. Go look on metalink first! If you don't have an account go get one. If you don't know what Metalink is you shouldn't be a DBA.
Why i am getting the error and how to avoid it.
2. No "can anyone here help me out please?" Just here's my error now tell me how to fix it. Grrrrrrrrr!!!
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
----------------------------------------------------------------
It's posts like this that really piss me off.
1. Go look on metalink first! If you don't have an account go get one. If you don't know what Metalink is you shouldn't be a DBA.
quote:
--------------------------------------------------------------------------------
Why i am getting the error and how to avoid it.
----------------------------------------------------------------------
2. No "can anyone here help me out please?" Just here's my error now tell me how to fix it. Grrrrrrrrr!!!
---------------------------------------------------------------------
Dear friend,
If you don't know the reply keep your mouth shut.
Regards
Pradipta
-
Dear Friend,
You are absolutely right,how horrible of me. You can find help with solving your problem here
If that doesn't help, let me know and I'll be more than happy to post a script here that will solve your entire problem.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
Hi Friend,
I regret for my behavior, sorry for the same.
regards
Pradipta
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|