El envío de formularios en el sitio de soporte no está disponible temporalmente para programar el mantenimiento. Si necesita asistencia inmediata, comuníquese con el soporte técnico. Disculpe las molestias ocasionadas.
Generation of change scripts for object types is invalid
Descripción
Toad generates invalid change scripts for object types. Steps to reproduce the issue:
create 2 empty schemas for comparison: in this example, COMP1 (target) and COMP2 (Source)
run this in COMP1
CREATE OR REPLACE TYPE my_type AS OBJECT ( id NUMBER, name VARCHAR2(100) );
create table my_type_table of my_type; run this in the other COMP2
CREATE OR REPLACE TYPE my_type AS OBJECT ( id NUMBER, name VARCHAR2(100) );
create table my_type_table of my_type;
ALTER TYPE my_type ADD ATTRIBUTE (email VARCHAR2(100)) cascade; Note: Oracle tracks the changes to the TYPE in DBA_TYPE_VERSIONS. There you can see the versions of the type before and after the ALTER TYPE statement. Toad uses the version info here to compare and sync
Compare them using COMP2 as source and COMP1 as target.
The only object types you need to include are tables and types
The sync script looks like below.
ALTER TYPE COMP1.my_type ADD ATTRIBUTE (email VARCHAR2(100)) cascade;
CREATE OR REPLACE TYPE COMP1.my_type AS OBJECT ( id NUMBER, name VARCHAR2(100) ) ALTER TYPE my_type ADD ATTRIBUTE (email VARCHAR2(100)) cascade /
SHOW ERRORS;
ALTER TABLE COMP1.MY_TYPE_TABLE ADD (EMAIL VARCHAR2(100 BYTE));
Bug: The only valid statement here is the first one.
The “Create or replace type” is unnecessary because we already altered it.
“Show errors” is actually harmless.
The “Alter table” is invalid because you can’t add columns to type tables.
Debe iniciar sesión
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Bienvenido al portal de soporte
Puede encontrar ayuda de soporte en línea para el *producto* Quest en un sitio de soporte afiliado. Haga clic en Continuar para ser dirigido al contenido de soporte y a la asistencia adecuados para el *producto*.