Topic: Database Administration >> error during upgarde from 9.2.0.7 to 9.2.0.8
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: error during upgarde from 9.2.0.7 to 9.2.0.8 |
| sumi |
Posted: Nov 18, 2007 01:12:33 AM |
Total Post: 8
Joined: Feb, 2007
|
Hi All,
I am upgarding our DB from 9.2.0.7 -9.2.0.8 in UNIX .When I run the catpatch.sql script, I get the following errors.
ORA-22319: type attribute information altered in ALTER TYPE
How can I rectify this error.
Please advice. |
|
|
 Babu |
| Posted: Nov 18, 2007 05:40:00 AM |  |
|
Total Post: 90
Joined: Oct, 2007
|
ORA-22319: type attribute information altered in ALTER TYPE
Cause: The type attribute information does not match that of the original type declaration when altering type. Attributes cannot be altered during ALTER TYPE. Only new methods can be added.
Action: Check that all type alterations are legal.
|
|
|
|
|
| sumi |
| Posted: Nov 19, 2007 01:08:08 AM | |
|
Total Post: 8
Joined: Feb, 2007
|
Hi,
Can you please advice me where to go and corrcet this error?
|
|
|
|
|
| Babu |
| Posted: Nov 19, 2007 03:24:18 AM | |
|
Total Post: 90
Joined: Oct, 2007
|
For example, assume that the following is used to create an object
type and an object table:
create or replace type address as object (city varchar2(10), state char(2));
/
create table address_tab of address;
insert into address_tab values ('Orlando', 'FL');
insert into address_tab values ('Boston', 'MA');
You then attempt to change the attribute definition of 'city'
from varchar2(10) to varchar2(20) using 'alter type' as shown below:
alter type address replace as object (city varchar2(20), state char(2));
The error occurs after issuing this command.
Additional Search Words
-----------------------
ORA 22319
Solution Description
--------------------
The attributes definition cannot be changed using 'alter type'.
The feature to change the definition of attributes is not yet
implemented.
To workaround the problem, drop the type. When trying to drop the
type with table dependencies, however, you receive the following
error:
ORA-02303: cannot drop or replace a type with type or table dependents
For example:
SQL> drop type address;
drop type address
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
In this case, issue the following command:
SQL> drop type address force;
Type dropped.
The dependent tables become invalid after the type is dropped:
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
