| View created over db link from 9i to 806 field sizes changes [message #129327] |
Sun, 24 July 2005 03:00 |
shad
Messages: 50
Registered: October 2000
|
Member |
|
|
Hi there
I created a view from the Oracle 9i database over a db link to Oracle 8.0.6 database. When DESCRIBE the view some fields are now varchar2(24) instead of varchar2(8) which is the case on a base table.
This is the DESCRIBE of the view
SQL> desc myoffice1
Name Null? Type
----------------------------------------- -------- ----------
OFFICE_CODE NOT NULL CHAR(24)
TYPE_CODE CHAR(24)
This is the DESCRIBE of the table
SQL> desc NAMS.OFFICE@dblink
Name Null? Type
----------------------------------------- --------
OFFICE_CODE NOT NULL CHAR(8)
TYPE_CODE CHAR(8)
The table is in an Oracle 8 database
There is a db link from Oracle 9i database to the Oracle 8 database
The view is in the Oracle 9i database
Regards
Shad
[MOD-EDIT: cleared smileys]
[Updated on: Sun, 24 July 2005 05:00] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
