ORA-12842: Cursor invalidated during parallel execution
Answers were Sorted based on User's Feedback
Answer / guest
Cause: The cursor was invalidated during the parse phase of
deferred parallel processing, e.g. when set operands are
parallelized.
Action: Depends on why the cursor was invalidated. Possible
causes include DDL on a schema object and shared pool being
flushed.
Please add more information about this Error
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / prepareinterview
1. What are the components of physical database structure of
Oracle database?
Oracle database is comprised of three types of files. One or
more datafiles, two are more redo log files, and one or more
control files.
2. What are the components of logical database structure of
Oracle database?
There are tablespaces and database's schema objects.
3. What is a tablespace?
A database is divided into Logical Storage Unit called
tablespaces. A tablespace is used to grouped related logical
structures together.
4. What is SYSTEM tablespace and when is it created?
Every Oracle database contains a tablespace named SYSTEM,
which is automatically created when the database is created.
The SYSTEM tablespace always contains the data dictionary
tables for the entire database.
5. Explain the relationship among database, tablespace and
data file.
Each databases logically divided into one or more
tablespaces one or more data files are explicitly created
for each tablespace.
Check out for more...
http://www.prepareinterview.com/tips/questiondatabase.asp
Is This Answer Correct ? | 2 Yes | 3 No |
ORA-31210: DBMS_LDAP: PL/SQL - LDAP get_dn error.
ORA-22801: invalid object row variable
LSX-00300: group must have name or ref but not both
EXP-00066: Object table string is missing its object identifier index
ORA-19330: Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator
ORA-07570: szrfc: $IDTOASC failure
ORA-13011: value is out of range
ORA-06026: NETASY: port close failure
NNO-00260: loading configuration data from checkpoint file "string"
NNL-00985: Requests reforwarded using referrals: number
ORA-02737: osnpcl: cannot tell orapop to exit
DRG-10829: feedback id string is longer than the maximum length of string bytes