Hi,
I try to export and import one db (11.2.0.4) to another server. Export is ok without any errors. Import also looks ok, just few compilation errors. Bud what is the big problem is export and import of objesct "TYPE". On the source look DDL different then on the target after import. I donlt know much about types, but I'm wonder about the alters after the creation command. I did sql file from exported dump and all alters are in the dump but there are not implemented. I also tried to run sql skript generate from dump and also without success. Only solution is copy and paste by hand. I tried to use transform=OID:"Y" and also "N" but I don't see any difference.
Does have anybody any idea why is it? Why ddl generate by expdp or dbms_metadata.get_ddl for type has create or replace command and many alters? How should I migrate types from one db to another.
Thank for any idea.
Jana
__TARGET DATABASE
create or replace TYPE "DIPA_POZADAVEK" as object (
typ_pozad varchar2(64),
pozad_id varchar2(32),
uziv_id varchar2(32),
apl_id varchar2(32),
findassignrange dipa_findassignrange,
assignrange dipa_assignrange,
freerange dipa_freerange,
extendrange dipa_extendrange,
reducerange dipa_reducerange,
confirmchangerange dipa_confirmchangerange,
cancelchangerange dipa_cancelchangerange,
updaterange dipa_updaterange,
createRangeGroup dipa_createrangegroup,
deleteRangeGroup dipa_deleterangegroup,
updateRangeGroup dipa_updaterangegroup
)
ALTER TYPE "DIPA_POZADAVEK"
add attribute getRangeList dipa_getrangelist
cascade
ALTER TYPE "DIPA_POZADAVEK"
add attribute moveRange dipa_moverange
cascade
ALTER TYPE "DIPA_POZADAVEK"
add attribute findMoveRange dipa_findmoverange
cascade
ALTER TYPE "DIPA_POZADAVEK"
add attribute getrangeinfo dipa_getrangeinfo
cascade
ALTER TYPE "DIPA_POZADAVEK"
drop attribute getrangeinfo
cascade
ALTER TYPE "DIPA_POZADAVEK"
add attribute getrangeinfo dipa_getrangeinfo
cascade
ALTER TYPE "DIPA_POZADAVEK"
drop attribute extendrange,
drop attribute reducerange,
add attribute changerangesize dipa_changerangesize
cascade
ALTER TYPE "DIPA_POZADAVEK"
add attribute getgroupinfo dipa_getgroupinfo
cascade
;
__SOURCE DATABASE
create or replace TYPE "DIPA_POZADAVEK" as object (
typ_pozad varchar2(64),
pozad_id varchar2(32),
uziv_id varchar2(32),
apl_id varchar2(32),
findassignrange dipa_findassignrange,
assignrange dipa_assignrange,
freerange dipa_freerange,
extendrange dipa_extendrange,
reducerange dipa_reducerange,
confirmchangerange dipa_confirmchangerange,
cancelchangerange dipa_cancelchangerange,
updaterange dipa_updaterange,
createRangeGroup dipa_createrangegroup,
deleteRangeGroup dipa_deleterangegroup,
updateRangeGroup dipa_updaterangegroup
)
alter type dipa_pozadavek
add attribute getRangeList dipa_getrangelist
cascade
alter type dipa_pozadavek
add attribute moveRange dipa_moverange
cascade
alter type dipa_pozadavek
add attribute findMoveRange dipa_findmoverange
cascade
alter type dipa_pozadavek
add attribute getrangeinfo dipa_getrangeinfo
cascade
alter type dipa_pozadavek
drop attribute getrangeinfo
cascade
alter type dipa_pozadavek
add attribute getrangeinfo dipa_getrangeinfo
cascade
alter type dipa_pozadavek
drop attribute extendrange,
drop attribute reducerange,
add attribute changerangesize dipa_changerangesize
cascade
alter type dipa_pozadavek
add attribute getgroupinfo dipa_getgroupinfo
cascade
alter type dipa_pozadavek
add attribute joinrange dipa_joinrange
cascade
alter type dipa_pozadavek
add attribute freerangelist dipa_freerangelist
cascade
alter type dipa_pozadavek add
attribute releaserange dipa_releaserange cascade NOT INCLUDING TABLE DATA
alter type dipa_pozadavek drop
attribute joinrange cascade NOT INCLUDING TABLE DATA
alter type dipa_pozadavek add
attribute joinranges dipa_joinranges cascade NOT INCLUDING TABLE DATA
alter type dipa_pozadavek add attribute synchronizeblock dipa_synchronizeblock cascade NOT INCLUDING TABLE DATA
alter type dipa_pozadavek add attribute saverozsah_o_detail dipa_saverozsah_o_detail cascade NOT INCLUDING TABLE DATA
alter type dipa_pozadavek add attribute deleterozsah_o_detail dipa_deleterozsah_o_detail cascade NOT INCLUDING TABLE DATA
alter type dipa_pozadavek add attribute getrozsah_o_detaillist dipa_getrozsah_o_detaillist cascade NOT INCLUDING TABLE DATA
alter type dipa_pozadavek add attribute createrange dipa_createrange cascade NOT INCLUDING TABLE DATA
alter type dipa_pozadavek add attribute deleterange dipa_deleterange cascade NOT INCLUDING TABLE DATA