Current Position:Home > ora 39142

ora 39142

  • ORA-39142: incompatible version Updated:11-30

    Dear DBA's I am planning to export and import tables data using DATAPUMP. Source DB ====== DB version = Target DB ====== DB Version = Export ==== I successfullu Exported the data by running bellow command. expdp eims_sms/oracle TABL

  • Expdp from diff home Updated:11-30

    Hi if i m having two oracle home 10g and 11g on same server and i want to do expdp of 11g database from 10g home is it possible ? for exp it is possible but i m not able to do it using expdp plz suggestCarlovski wrote: OK, yes, you could use the expd

  • How to tell what type of dump? Updated:11-30

    Hi, I was given a backup file EXPDAT.dmp to be loaded at my test database. It was not indicated what type of export created this dump. How do I know if it is at output of exp or expdp? Thanks a lotthanks, I already granted access permission. but I go

  • DATAPUMP PROBLEM Updated:11-30

    Hi, I am running datapump: C:\>impdp system/manager directory=dp_dir dumpfile=CISADM_EXPDP_042011.dmp sqlfile=a.sql Import: Release - Production on Mon May 9 10:53:45 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights

  • PL/SQL report errors: ORA-01422 Updated:10-11

    Hi all, (before i you read i would like to say i have searched the net for this error code but nothing shows up like this problem..) I am getting an error problem when i select certain Schemas from a list on an apex app. page, it only works for some

  • Ora-00604 error and ora 01000 error while report generation. Updated:10-11

    hi all, I am trying to generate the multiple reports of same template through a program. While this job is running, i get the following error at the BIP console and the reports don't get generated. [101711_044115578][][EXCEPTION] java.sql.SQLExceptio

  • EA2: ORA-01427 clicking on a view in the navigator Updated:10-11

    SQLDev: Java: 1.6.0_04 Oracle: I'm getting the following error when I click on a view in the navigator pane: An error was encountered performing the requested operation: ORA-01427: single-row subquery returns more than one row 0

  • Using database-link in view to get around ORA-01031 error Updated:10-11

    I have been granted select rights on a users table. I am therefore able to select from his table. If however I try create a view against his table I run into the ORA-01031 problem. I have worked around this problem by creating a database-link to myse

  • Getting ora:00904 invalid indentifier error while running i query Updated:10-11

    Hi, I have a remote database and local database both are oracle 10gR2.Now i have written the below mentioned query in my local database and is working fine,but in case remote database it is throughing error ora:00904 invalid indentifier. I had export

  • 'ORA-01722: Invalid Number' error while Running a Query Updated:10-11

    Hi, I'm trying to run a query built on a DSO. The DSO has a field 'Start Date'. This Start Date InfoObject has a reference Char as 0DATE. This Start Field has blank values due to which I'm getting the ORA-01722 error. I came across many threads with

  • ORA-12712 error while changing nls character set to AL32UTF8 Updated:10-11

    Hi, It is strongly recommend to use database character set AL32UTF8 when ever a database is going to used with our XML capabilities. The database character set in the installed DB is WE8MSWIN1252. For making use of XML DB features, I need to change i

  • While updating a table i am getting ORA-00600 error. Updated:10-11

    Hi all, While updating a table i am getting the following: **SQL Error: ORA-00600: internal error code, arguments: [qkebCreateConstantOpn1], [], [], [], [], [], [], [], [], [], [], []** **00600. 00000 - "internal error code, arguments: [%s], [%s], [%

  • Error while adding Image: ORA-00001: unique constraint Updated:10-11

    Dear all, I have an error while adding images to MDM I can´t explain. I want to add 7231 images. About 6983 run fine. The rest throws this error. Error: Service 'SRM_MDM_CATALOG', Schema 'SRMMDMCATALOG2_m000', ERROR CODE=1 ||| ORA-00001: unique const

  • ORA-600 [17069] error while running catrelod.sql to downgrade 11g database Updated:10-11

    Hi, We are downgrading our database to We have successfullly run catdwgrd.sql without any errors in 11g env. While running catrelod.sql in 10g env we are facing the following error: SQL> @?/rdbms/admin/catrelod.sql TIMESTAMP COMP_T

  • Ora-00604,ora-01422 error while dropping the table Updated:10-11

    Hi gurus, I am using Oracle 10g R2 on windows 2000 platform,while dropping the table the following error occured. ORA-00604 : error occurred at recursive sql level 1. ORA-01422: exact fetch returns more than requested number of rows. Need urgent help

  • Ora-00600 error when dropping a table Updated:10-11

    Oracle Database 11g Enterprise Edition Release - 64bit Production When I tried to drop a table, I got 600 error: SQL> desc DEV.ATTR_IDX$EX Name Null? Type NODE_ID NOT NULL NUMBER COL1 NUMBER SQL> show user; USER is "DEV" SQL>

  • ORA-00600: internal error code, arguments: [ktsircinfo_num1] Updated:10-11

    While taking export of a table received EXP error and while dropping/selecting the same gor ora-600 errors. . . exporting table TEST4 EXP-00003: no storage definition found for segment(29, 371385) SQL >Drop table test4 cascade; ORA-00600: internal er

  • Error ora-15081 (and several others) while creating a new db in Solaris Updated:10-11

    Hi all, OS: Solaris 11 DB: (2 node rac) While creating a new db on a Solaris 11 env, via dbca, the following stack error appeared to me: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece path[...] OR

  • OIM ORA-0936 encountered when provisioning roles Updated:10-11

    I've configured an Access Policy that provisions users without requiring approval to a DB through the DB connector. It also provisions them with roles: CONNECT and DBA. The latter was achieved by making Role provisioning dependent upon User creation

  • ORA-03111 - JCA Binding error while invoking a stored procedure in DB Updated:10-11

    Hi, We are facing this problem for one interface alone. Need expert advice to fix this problem.. This is scheduled to run once in a day and fails daily for past 2 weeks.. We receive below error as response.. Same interface worked fine for past 1 yr..