0% found this document useful (0 votes)
14 views7 pages

Oracle Data Model Changes 11.5.10.2 to 12.1.1

The document summarizes the differences between database objects in Oracle versions 11.5.10.2 and 12.1.1. It found differences in regular tables, partitioned tables, global temp tables, indexes, sequences, and packages. The key changes were the addition of 29 new regular tables, 1 new partitioned table, and modifications to indexes, sequences and packages in the 12.1.1 version.
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
14 views7 pages

Oracle Data Model Changes 11.5.10.2 to 12.1.1

The document summarizes the differences between database objects in Oracle versions 11.5.10.2 and 12.1.1. It found differences in regular tables, partitioned tables, global temp tables, indexes, sequences, and packages. The key changes were the addition of 29 new regular tables, 1 new partitioned table, and modifications to indexes, sequences and packages in the 12.1.1 version.
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Product:AD

Regular_Tables ('29' differences found)


Partitioned_Tables ('1' differences found)
Queue_Tables (No differences found)
Index_Orgnized_Tables (No differences found)
Global_Temp_Tables ('1' differences found)
Indexes ('17' differences found)
Views (No differences found)
Sequences ('23' differences found)
Materialized_Views (No differences found)
Materialized_View_Logs (No differences found)
Advanced_Queues (No differences found)
Triggers (No differences found)
Packages ('16' differences found)
Types (No differences found)

Regular tables: ('29' differences found)


Regular tables
Object Definition Differences Between [Link] and 12.1.1
ADX_PRE_AUTO
Added in 12.1.1
CONFIG
AD_FIXED_ISSU
Added in 12.1.1
ES
AD_MANUAL_ST
Added in 12.1.1
EP_HISTORY
AD_OBSOLETE_
Added in 12.1.1
OBJECTS
AD_PARALLEL_
UPDATE_UNITS_
Added in 12.1.1
BKP
AD_PATCH_CON
Added in 12.1.1
D_HISTORY
AD_PA_ANAL_R
UN_BUG_CODEL
Added in 12.1.1
EVELS
AD_PA_ANAL_R
UN_BUG_PRERE
Added in 12.1.1
QS
AD_PA_ENTITY_
Added in 12.1.1
INFO
AD_PA_PATCH_C
OND_REQUIRES_
Added in 12.1.1
INFO
AD_PA_PATCH_E
Added in 12.1.1
NTITY_INFO

AD_PA_PATCH_R
EQUIRES_INFO
AD_TE_LEVEL_H
ISTORY
AD_TRACKABLE
_ENTITIES
AD_UTIL_PARA
MS
AD_PARALLEL_
UPDATE_UNITS

Added in 12.1.1
Added in 12.1.1
Added in 12.1.1
Added in 12.1.1
Removed in 12.1.1

Objects Added in 12.1.1


col-BASELINE_NAME
AD_BUGS
col-GENERIC_PATCH
col-LANGUAGE
col-TRACKABLE_ENTITY_ABBR
Objects Added in 12.1.1
col-LANGUAGE
AD_CHECK_FILE col-SERVER_TYPE_ADMIN_FLAG
_TEMP
col-SERVER_TYPE_FORMS_FLAG
col-SERVER_TYPE_NODE_FLAG
col-SERVER_TYPE_WEB_FLAG
AD_COMPRISIN Objects Added in 12.1.1
G_PATCHES
col-PATCH_ABSTRACT
AD_FEATURE_V Attribute Changes between [Link] and 12.1.1
ERSIONS
col-FILENAME:char_length:50 => 60
Objects Added in 12.1.1
AD_FILES
col-FLAGGED_FILE_COMMENTS
col-IS_FLAGGED_FILE
AD_PATCH_DRIV Objects Added in 12.1.1
ERS
col-PATCH_ABSTRACT
Objects Added in 12.1.1
col-BASELINE_NAME
AD_PATCH_HIST
col-GENERIC_PATCH
_TEMP
col-LANGUAGE
col-TRACKABLE_ENTITY_NAME
AD_PATCH_RUN Attribute Changes between [Link] and 12.1.1
S
col-PROGRAM_RUN_ID:nullable:N => Y
AD_PA_ANALYSI Objects Added in 12.1.1
S_RUNS
col-REQUEST_SET_ID
Objects Added in 12.1.1
AD_PA_ANALYSI col-ANALYSIS_RUN_BUG_ID
S_RUN_BUGS col-BASELINE
col-HAS_MSI_STEPS
AD_PM_PATCHE Objects Added in 12.1.1

col-BASELINE
col-ENTITY_ABBR
col-HAS_MSI_STEPS
S
col-IS_CODE_LEVEL
col-PATCH_ID
col-PATCH_TYPE
Attribute Changes between [Link] and 12.1.1
AD_PROGRAM_R
col-JOB_NAME:char_length:50 => 60
UN_TASK_JOBS
col-SUBDIRECTORY:char_length:30 => 256
Attribute Changes between [Link] and 12.1.1
AD_TASK_TIMIN
col-JOB_NAME:char_length:50 => 60
G
col-SUBDIRECTORY:char_length:30 => 256
Top
Partitioned tables: ('1' differences found)
Partitioned tables
Object Definition Differences Between [Link] and 12.1.1
AD_PARALLEL_
Added in 12.1.1
UPDATE_UNITS
Top
Queue Tables: (No differences found)
Queue Tables
Object Definition Differences Between [Link] and 12.1.1
Top
Index Orgnized Tables: (No differences found)
Index Orgnized Tables
Object Definition Differences Between [Link] and 12.1.1
Top
Global temp tables: ('1' differences found)
Global temp tables
Object Definition Differences Between [Link] and 12.1.1
Objects Added in 12.1.1
col-FILE_EXTENSION
AD_PROCESSED
_FILES_TEMP
Objects Removed in 12.1.1
col-FILE_EXTN
Top
Indexes: ('17' differences found)
Indexes
Object Definition Differences Between [Link] and 12.1.1
AD_BUGS_N1
Added in 12.1.1
AD_FILES_N1
Added in 12.1.1
AD_MANUAL_ST
Added in 12.1.1
EP_HISTORY_U1
AD_PATCH_RUN
_SESS_ATTRIBS_
Added in 12.1.1
N1
AD_PA_ANALYSI
Added in 12.1.1

S_RUNS_U2
AD_PA_ANALYSI
S_RUN_BUGS_N1
AD_PA_PATCH_C
OND_REQS_INFO
_U1
AD_PA_PATCH_E
NTITY_INFO_U1
AD_PA_PATCH_R
EQUIRES_INFO_
U1
AD_PM_PATCHE
S_U2
AD_PROGRAM_R
UN_TASKS_N2
AD_TASK_STATU
S_N2
AD_TRACKABLE
_ENTITIES_U1

AD_BUGS_U2

Added in 12.1.1
Added in 12.1.1
Added in 12.1.1
Added in 12.1.1
Added in 12.1.1
Added in 12.1.1
Added in 12.1.1
Added in 12.1.1
Objects Added in 12.1.1
tab-AD_BUGS:col:BASELINE_NAME
tab-AD_BUGS:col:LANGUAGE
tab-AD_BUGS:col:TRACKABLE_ENTITY_ABBR
Attribute Changes between [Link] and 12.1.1
tab-AD_BUGS:col:ARU_RELEASE_NAME:column_position:2 => 3
tab-AD_BUGS:col:BUG_NUMBER:column_position:1 => 2

AD_PARALLEL_
Objects Added in 12.1.1
UPDATE_UNITS_
tab-AD_PARALLEL_UPDATE_UNITS:col:UNIT_ID
N1
Objects Added in 12.1.1
tab-AD_PA_ANALYSIS_RUN_BUGS:col:BASELINE
AD_PA_ANALYSI
S_RUN_BUGS_U1
Objects Removed in 12.1.1
tab-AD_PA_ANALYSIS_RUN_BUGS:col:APPL_TOP_ID
Objects Added in 12.1.1
tab-AD_PM_PATCHES:col:BASELINE
AD_PM_PATCHE
Attribute Changes between [Link] and 12.1.1
S_U1
tab-AD_PM_PATCHES:col:BUG_NUMBER:column_position:1 => 2
tab-AD_PM_PATCHES:col:PATCH_METADATA_KEY:column_position:2 =>
1
Top
Views: (No differences found)

Views

Object Definition Differences Between [Link] and 12.1.1


Top

Sequences: ('23' differences found)


Sequences
Object Definition Differences Between [Link] and 12.1.1
AD_ANALYSIS_R
Added in 12.1.1
UN_BUG_ID_S
AD_APPLIED_PA Attribute Changes between [Link] and 12.1.1
TCHES_S
cache_size:20 => 1000
AD_APPL_TOPS_ Attribute Changes between [Link] and 12.1.1
S
cache_size:20 => 1000
Attribute Changes between [Link] and 12.1.1
AD_BUGS_S
cache_size:20 => 1000
AD_COMPRISIN Attribute Changes between [Link] and 12.1.1
G_PATCHES_S cache_size:20 => 1000
Attribute Changes between [Link] and 12.1.1
AD_FILES_S
cache_size:20 => 1000
AD_FILE_VERSI Attribute Changes between [Link] and 12.1.1
ONS_S
cache_size:20 => 1000
AD_MANUAL_ST
Added in 12.1.1
EP_HISTORY_S
AD_PATCH_COM
Attribute Changes between [Link] and 12.1.1
MON_ACTIONS_
cache_size:20 => 1000
S
AD_PATCH_CON
D_REQUIRES_ID
Added in 12.1.1
_S
AD_PATCH_DRIV Attribute Changes between [Link] and 12.1.1
ERS_S
cache_size:20 => 1000
AD_PATCH_DRIV Attribute Changes between [Link] and 12.1.1
ER_LANGS_S cache_size:20 => 1000
AD_PATCH_DRIV Attribute Changes between [Link] and 12.1.1
ER_MINIPKS_S cache_size:20 => 1000
AD_PATCH_ENTI
Added in 12.1.1
TY_ID_S
AD_PATCH_ID_S
Added in 12.1.1
AD_PATCH_REQ
Added in 12.1.1
UIRES_ID_S
AD_PATCH_RUN Attribute Changes between [Link] and 12.1.1
S_S
cache_size:20 => 1000
AD_PATCH_RUN Attribute Changes between [Link] and 12.1.1
_BUGS_S
cache_size:20 => 1000
AD_PATCH_RUN Attribute Changes between [Link] and 12.1.1

_BUG_ACTIONS_
cache_size:20 => 1000
S
Attribute Changes between [Link] and 12.1.1
AD_RELEASES_S
cache_size:20 => 1000
AD_SNAPSHOTS Attribute Changes between [Link] and 12.1.1
_S
cache_size:20 => 1000
AD_SNAPSHOT_ Attribute Changes between [Link] and 12.1.1
BUGFIXES_S cache_size:20 => 1000
AD_SNAPSHOT_ Attribute Changes between [Link] and 12.1.1
FILES_S
cache_size:20 => 1000
Top
Materialized Views: (No differences found)
Materialized Views
Object Definition Differences Between [Link] and 12.1.1
Top
Materialized View Logs: (No differences found)
Materialized View Logs
Object Definition Differences Between [Link] and 12.1.1
Top
Advanced Queues: (No differences found)
Advanced Queues
Object Definition Differences Between [Link] and 12.1.1
Top
Triggers: (No differences found)
Triggers

Object Definition Differences Between [Link] and 12.1.1


Top

Packages: ('16' differences found)


Packages
Object Definition Differences Between [Link] and 12.1.1
Objects Added in 12.1.1
AD_FILE_UTIL
proc-LOAD_SNPST_FILE_SERVER_INFO
AD_MANUAL_ST
Added in 12.1.1
EP_OBJECT
Objects Added in 12.1.1
AD_MORG
proc-REPLICATE_TABLE_DATA_BULK
AD_MO_UTIL_P
Added in 12.1.1
KG
AD_OBSOLETE_
Added in 12.1.1
PRODUCTS
Objects Added in 12.1.1
proc-GET_ROWID_RANGE_WRAPPER
AD_PARALLEL_
Attribute Changes between [Link] and 12.1.1
UPDATES_PKG
proc-INITIALIZE_ID_RANGE:arg:X_END_ID:Added in 12.1.1
proc-INITIALIZE_ID_RANGE:arg:X_BEGIN_ID:Added in 12.1.1
proc-INITIALIZE_ID_RANGE:arg:X_SQL_STMT:Added in 12.1.1

AD_PATCH

Objects Added in 12.1.1


func-IS_PATCH_APPLIED
func-IS_CODELINE_PATCH_APPLIED
func-IS_CODELINE_PATCH_APPLIED(overloaded_1)

AD_PATCH_ANA
LYSIS_ENGINE

Added in 12.1.1

Objects Added in 12.1.1


AD_PATCH_IMPA
proc-GET_RECOMMEND_PATCH_LIST
CT_API
proc-GET_PREREQ_LIST
AD_PA_INSERT_P Objects Added in 12.1.1
ACKAGE
proc-INSERT_AD_PM_PATCHES
AD_PA_MISC
Added in 12.1.1
Objects Added in 12.1.1
proc-SUBMIT_AGGREGATE_IMPACT
AD_PA_SUBMIT_
REQUEST
Attribute Changes between [Link] and 12.1.1
proc-SUBMIT_PATCHES_REQUEST:arg:PISAGGREGATE:Added in 12.1.1
proc-SUBMIT_ADVISOR_REQUEST:arg:PISAGGREGATE:Added in 12.1.1
Objects Added in 12.1.1
proc-GET_FILES
proc-GET_ALL_FILES
AD_POST_PATCH Attribute Changes between [Link] and 12.1.1
proc-SET_GATHERED_FLAG:arg:P_APPLSYS_USER_NAME:Removed in
12.1.1
proc-SET_GATHERED_FLAG:arg:P_FILE_EXTENSION_LIST:Removed in
12.1.1
AD_TRACKABLE
Added in 12.1.1
_ENTITIES_PKG
AD_SIZING
Removed in 12.1.1
Attribute Changes between [Link] and 12.1.1
ADX_PRF_PKG
proc-SET_PROFILE:arg:P_LEVEL_VALUE2:Added in 12.1.1
Top
Types: (No differences found)
Types

Object Definition Differences Between [Link] and 12.1.1

You might also like