Friday, January 22, 2016

LD Login Error Table Definitions have undergone a change



select table_name from dba_tables where owner='LDBO' and temporary = 'Y' and table_name='TBLTEMPOPERATIONSTATISTICS';

DRop TABLE "LDBO"."TBLTEMPOPERATIONSTATISTICS" ;

  CREATE GLOBAL TEMPORARY TABLE "LDBO"."TBLTEMPOPERATIONSTATISTICS"
   ( "NOPERCODE" NUMBER(3,0),
"NSUBCODE" NUMBER(3,0),
"COPERATIONNAME" VARCHAR2(100 BYTE),
"CSTARTTIME" DATE,
"CENDTIME" DATE,
"NTOTALROWS" NUMBER(12,0),
"NINITIALROWS" NUMBER(12,0),
"NFETCHROWS" NUMBER(12,0)
   ) ON COMMIT PRESERVE ROWS ;

No comments:

Post a Comment

Followers