Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Value Too Large error on schema reverse into Designer9i

Status
Not open for further replies.
tallbloke

tallbloke

Programmer
Aug 1, 2003
3
GB
Hi there. I'm trying to reverse a schema into a Designer9i repository and keep getting 'value inserted is too large for column' error.

I first installed base 9.0.2 version (from Oracle9iDS disk), created repository and then tried to reverse the schema in using the Oracle supplied jr_registration.register packaged procedure.

The process got through about 10 tables and then failed with the error on a table that contains a BLOB column.

Then I applied the 9.0.2.5 patch thinking this might fix it. Applied patch and upgraded repository (all fine). Re-ran jr_registration.register and it failed at same point.

Anyone ideas on getting round this?

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
336
carp
carp
TheLazyPig
  • Locked
  • Question
Separate 1 row value to multiple rows
Replies
4
Views
356
carp
carp
Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
448
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
396
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
343
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top