Database Errors Interview Questions
Questions Answers Views Company eMail

AMD-00130: dimension #string: RDBMS dimension column data type not specified

1 2629

AMD-00131: dimension #string: RDBMS parent column data type not specified

1 2205

AMD-00132: dimension #string: RDBMS GID column data type not specified

1 2213

AMD-00133: measure #string: analytic workspace measure name not specified

1 2092

AMD-00134: measure #string: RDBMS measure column name not specified

1 2163

AMD-00135: measure #string: RDBMS measure column data type not specified

1 2658

AMD-00136: Generation of SQL script "string" failed

1 2367

AMD-00137: prefix "string" exceeds maximum permitted length of string characters

1 2239

AMD-00138: level names parameter not null or defaulted

1 2069

AMD-00139: level names parameter not valid

1 2290

AMD-00140: internal error: [string] [string] [string] [string] [string]

1 3061

AMD-00141: parameter string of "string" not valid starting around "string"

1 2155

AMD-00142: Analytic Workspace name "string" must be fully qualified with the Owner.

1 2481

AMD-00143: View name "string" must be fully qualified with the Owner.

1 2280

AMD-00144: Custom Measure "string" does not exist in Workspace "string"

1 2387


Un-Answered Questions { Database Errors }

ORA-16627: No standby databases support the overall protection mode.

3566


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2147


What severity level errors are managed in TRY-CATCH block?

1800


When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2078


ORA-26095: unprocessed stream data exists

2825






ORA-26029: index string.string partition string initially in unusable state

1722


ORA-26079: file "string" is not part of table string.string

1528


ORA-16516: The current state is invalid for the attempted operation.

8092


What is live lock, deadlock and what is Lock escalation?

1962


why we are using shift key in unix shell script

2602


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

1758


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1250


How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2177


When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2330


IMP-00064: Definition of LOB was truncated by export

5901