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
CMS-XML "sqlerrm = ORA-20000: Unable to set values for index [index name]" errors during Data Pump import.
When users import Dimensions CM data into an Oracle 19 database via IMPDP, it may return the following messages: Processing object type DATABASE_EXPORT/ STATISTICS /MARKER [index name] : sqlerrm = ORA-20000: Unable to set values for index [index name]: does not exist or insufficient privileges
CMS-XML KM-Dim8: Tuning Oracle for best performance with Dimensions
Dimensions 6 contains the command pcms_dbstats. This is used to create statistics on all the database schema objects . This is documented in the DBA Guide but basically running pcms_dbstats -e system/<password> will estimate statistics on all the database schema objects.
CMS-XML Dim10: How to maximize oracle database performance
... tables and index statistics , preferably before ... ... indexes and compute statistics for a given ... it on the oracle server (or on an Oracle client PC) ... ... of the current object size) so ... ... tables containing large objects (BLOBs and ... ... and if the statistics are up to ... set cursor_sharing to force (unless the oracle version is less than 9.2.0.6 because of a bug) ... Alternatively, configuring Oracle 10.2 Automatic Memory Management:
CMS-XML KM-Dim7: Oracle Bug 90081 may cause Dr. Watson application errors or core dumps when importing a full system export of an Oracle 8.1.5 database.
DIM: Oracle Bug 90081 may cause Dr. Watson application errors or core dumps when importing a full system export of an Oracle 8.1.5 database. ... a. Export with STATISTICS =NONE. Eg: EXP SYSTEM/MANAGER FULL=Y STATISTICS =NONE ... c. Perform a FULL import rather than importing an individual users objects . If necessary the import can be to a dummy database in order to perform a user level export of the desired schema / objects .
CMS-XML MCLG: Creating and configuring an Oracle database instance for Collage with Oracle 9i or 10g
... creating a new Oracle database instance for Collage ... If the statistics are up to date, it should not cause full table scan unnecessarily. ... to force (unless the Oracle version is less than 9.2.0.6 because of a bug) ... Create a tablespace with block size of 32k, and move all the tables containing large objects (CLOB and BLOB datatype) in this new tablespace. It would be better to have this tablespace layed on its own physical disks apart from the rest of the database.
CMS-XML Dim2009: How to obtain a timed trace of Oracle queries to locate and tune specific problem queries
Determine the Oracle session that we ... ... “Connection Pooling Statistics ”. ... the Connection Pooling Statistics page, use ... Use Oracle sqlplus to locate the Oracle session for this ... ... Dimensions Connection Pooling Statistics page displays a ... ... >@< oracle -sid> ... , insure that Oracle timed_statistics ... ... logged in to Oracle as the SYSTEM ... ... the currently running Oracle , but will ... the next time Oracle is restarted it ... ... initiated from the Oracle SYS account then ... be initiated from Oracle SYSTEM account. ... use the following Oracle query while logged ... ... tracefile, the Oracle utility tkprof is ...
HTML SBM Version Diff
Differences Between Versions ... $IF( ORACLE ) - // Oracle now uses CLOBs ... ... ; // Oracle now uses CLOBs ... { var obj = elements[ ... ... function CheckParentRowVisibility( obj , label) { if ( obj == null ... ... ) { var obj = GetFieldByName( ... ; if ( obj == null ... + var obj = GetFieldByName( ... ... + if ( obj == null ... ... using $( obj ).html ... ... + jQuerySBM( obj ).html ... ... columnSort = new Object (); ... ... function GetParentElement( obj , tagName) ...
HTML SQL*Plus Report
... _PENDING_ STATS SELECT ALL_ ... OBJ _COLATTRS SELECT ... OBJECTS SELECT ALL_ ... ... _PENDING_ STATS SELECT DBA_ ... ... _SAMPLE_ OBJ EXECUTE HTF EXECUTE ... ... INSERT IMPDP_ STATS DELETE IMPDP_ ... ... SELECT INDEX_ STATS SELECT INDIVIDUAL_ ... STATS _T EXECUTE ... ... _SRF EXECUTE ORA $BASE USE ... _BINNING EXECUTE ORA _KGLR7 ... _CHAR SELECT ORA ... UB1 SELECT ORA _KGLR7 ... OBJECT EXECUTE SDO_ ... ... EXECUTE SQL_ OBJECTS EXECUTE SQL_ ... OBJECTS INSERT USER_ ... _JAVA_ OBJECTS SELECT USER_ ... OBJECTS SELECT USER_ ...
CMS-XML Problem: ORA-08103 Object no longer exists
When performing a query, the error message "[Intersolv] [ODBC Oracle Driver] [Oracle] ORA-08103: object no longer exists" occurs.
CMS-XML KM-Dim6: During TBO, user gets error: SQL-0136-14(12119) ORA-00955: name is already used by an existing object
KM-Dim6: During TBO, user gets error: SQL-0136-14(12119) ORA -00955: name is already used by an existing object
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs