Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
TEXT Delete Respository Tables-Oracle.txt
; DROP INDEX IDX_BY_ASSETVERID_PROPID; DROP INDEX IDX_BY_USERID_SYSPERM; alter table OR_ASSETTYPE drop constraint FK_ASSETTYPE_REF_AV; alter table OR_ASSETTYPE drop constraint FK_ASSETTYPE_REF_ASSETTYPE; alter table OR_ASSETVERSION drop constraint FK_ASSETVERSION_REF_ASSET; alter table OR_ASSETVERSION drop constraint FK_
CMS-XML Application Repository - SQL Server database deadlocks getting Activity Details when very large number of records
1. select COUNT(*) from OR_ASSETVERSION select COUNT(*) from OR_AUDITENTRY
CMS-XML SBM Database Index definitions used in all databases for 11.2
CREATE INDEX IDX_BY_USERID_ASSETPERM ON OR_ASSET_PERMISSION (USERID); CREATE INDEX IDX_BY_ASSETID_VERSION ON OR_ASSETVERSION (ASSET_ID, VERSION); CREATE INDEX IDX_BY_AUDITENTRYID_ASSET ON OR_AUDITASSETCHANGE (AUDITENTRY_ID);
CMS-XML Not able to open Environment->Deploy History - error - Unable to load relation 'history
ID as LOCK5_1_0_, av.DELETED as DELETED1_0_, av.PURGED as PURGED1_0_, av.ASSET_ID as ASSET8_1_0_, av.DELETED_TIME as DELETED9_1_0_, av.ASSETTYPE_ID as ASSETTYPE10_1_0_ FROM OR_ASSETVERSION
CMS-XML Repository: Process App view gives error "Unable to load relation 'versions'."
ae.AUDITENTRY_ID IN \n (\n SELECT DISTINCT ac.AUDITENTRY_ID\n FROM OR_AUDITASSETCHANGE ac, OR_ASSETVERSION av, OR_ASSET a\n WHERE av.ASSETVERSION_ID = ac.ASSETVERSION_ID AND a.ASSET_UUID IN () \n AND av.ASSET_ID = a.ASSET_ID\n AND a.NAMESPACE = ?\n
CMS-XML SBM: About the "Clear History" feature used to schedule Common Log cleanup (Delete Common Logger)
SELECT version.ASSETVERSION_ID FROM OR_ASSETVERSION version
PDF TeamTrack Database Schema
375 OR_ASSETVERSION This table contains all the version of objects (called assets) stored by SBM Application Repository.
PDF TeamTrack Database Schema
OR_ASSETVERSION ................................................................................................. ...
PDF TeamTrack Database Schema
OR_ASSETVERSION ................................................................................................. ...
PDF TeamTrack Database Schema
238 OR_ASSETVERSION This table contains all the version of objects (called assets) stored by Mashup Manager.
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs