What is SCD (Slowly Changing Dimensions)? What are its types?

1254

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...

1624

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

1123

IMP-00000: Import terminated unsuccessfully Hi all . when i go to restore oracle dmp file in my database ans typing this command , C:UsersW>imp HR2011/HR2011@XE TABLES=* dmpfile=F:Share223.27.244.72EXP 2017-0113030008FU160710ZIP/FU160710.DMP this message was showed to me and restore mission filed . LRM-00101: unknown parameter name 'dmpfile' IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help IMP-00000: Import terminated unsuccessfully how i can fix this problem plzzz

1589

What is the meaning of lock escalation and why/how to stop this?

1463

hi pp gurus, when i do the goods receipt through transiction MIGO the system, gives following error. I filled up all information that needs MIGO transiction. the error is: "Account determination for entry INT GBB___AUF 7900 not possible." can any one suggest me what to do now?

1359

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

5392

What is the major use of Servelet

1232

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

1072

Any body can tel me how to display a Frame Link of a page in Another Frame? For Clearance of my dought..... I designed a BSP page with 3 frames as shown below. -------------------------------- | | | Frame 1 | | | -------------------------------- | Frame 2 | Frame 3 | | | | | Link 1 | | | Link 2 | | | Link 3 | | | | | -------------------------------- Now in Frame 1 i displayed one page.. And in Frame 2 i displayed one page with some links. Now when i clicked on any Link in Frame 2 that corresponding Page has to display in Frame 3. In general HTML i know...But in BSP i don't know that much since i am new to this... plz any solutions...thanks a lot.... Regards, Shankar.

1173

ORA-16626: failed to enable specified object

1079

Wen ever i use IE=createObject (Ineternetexplorer.application) QTP just navigates to the URL mentioned but doesn't recognise the USErname and Password field so the test fails.. But wen i just record and use system.util "iexplore" the code recognises and the tst passes, but here it works fine sometimes and sometimes the test just fails and aftersometime i run it works.. so its not consistent,,, any suggestion

1708

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

1652

ORA-26028: index string.string initially in unusable state

2388

I-series. When I use: qtp DICTIONARY(PDMZZ) AUTO (*LIBL/MFR0120X)I get the error: *E* Can't open the file specified on the AUTO program parameter. File of different type already exists. When I use it auto without *libl ,qtp DICTIONARY(PDMZZ) AUTO (MFR0120X), it works fine

1615