Hi all,
We are changed our version of oracle from oracle7.3 to oracle8.1.7.
We have one application which is develped in VB
that is working fine with oracle7.3 as backend.
We have taken database fullbackup using exp73 in oracle7.3.
We imported that backup to oracle8.1.7 using imp.
Data is successfully imported and working fine in the SQL prompt.
The application which is develped in VB which is working fine with
oracle7.3 is used with oracle 8.1.7 to check the data and working of
our application .
But while access some of the data from some of the tables it is giving
"restricted attribute violation" with oracle odbc driver8.01.07.00.
We found this is because of the null values in table in some of the fields.
If we replace those null values with some other values it is working fine.
If we create any table in that database and insert null values than also it
is working fine.
But it is not working with the table which imported from our .dmp file.
1)Is there any procedure to be followed when we importing the .dmp file into
oracle8.1.7 database?
2)Is there is requirement for upgrading the odbc driver?
send me all the possible chances to solve this problem.
Thanks
