Oracle ORA-38029 - DBMS_STATS.UNLOCK_SCHEMA_STATS

I try run the analyze command:

analyze table cliente compute statistics;

and i get error ORA-38029

i run DBMS_STATS.UNLOCK_SCHEMA_STATS and run analyze table again and work's fine.........

Why Statics are LOCKED ??

Oracle Exclude MV Table from gather schema stats

I am running the daily stats gathering procedure below.But it is running at the same time with an MV that is refreshing,and it's failing due to that.Is it possible to exclude the Materialized view from the below schema stats procedure?BEGIN dbms_stats.gather_schema_stats(ownname=>'SCOTT',estimate ...

Oracle ORA -18808;Cannot find OUTLN schema using Database Link

I have to access a database using a database link. When I try to do so I get the message:ORA -18808:cannot find OUTLN schemaThe OUTLN schema really does'nt exist at the target database, but I don't get the message when connecting with the same user outside the database link.I am trying to avoid to a ...

Oracle ORA-31000 using global XML schema

HiI've got a problem with some global XML schemas in my database (version 10.1.0.3.0).I registered these schemas using the Enterprise Manager Console.I was logged into EM as user SYS but registered the schemas as owner TOOLS and scope visible to public.I pasted the schema text directly into EM not u ...

Oracle ORA-00600 error while registering schema

I am getting below error while registering the XML schema ERROR at line 1:ORA-00600: internal error code, arguments: [qmxiCreateColl2], [11], [], [], [], [], [], []ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 26ORA-06512: at line 2i am trying to execute the ...

Oracle ora-31000 not an XDB schema document error WHY???

I have registered a xmlschema as followingFIRSTLYI create a procedure schemas ascreate or replace procedure schemas isbegindeclaredoc varchar2(1000) := '<schema targetNamespace="http://localhost/po.xsd" xmlns:po="http://localhost/po.xsd" xmlns="http://www.w3.org/2001/XMLSchema"xmlns:xdb="http://x ...

Oracle ORA-20000 Error in SYS schema

i frequently get this error in the alert log of a production database size of more than 4TB.Tue Feb 26 22:00:26 2008Errors in file /unisoft/ora10/admin/unidb/bdump/unidb_j000_29859.trc:ORA-20000: index "SYS"."WRH$_ACTIVE_SESS_HIST_PK" or partition of such index is in unusable statemy concern is, whe ...

Oracle ORA-31000 Error for Registered Schema

I have seven schemas I am trying to register that I may build XMLType tables. The parent schema has 5 includes and 1 import.I had to use the force => TRUE option during their registration as the includes and import reference types within the parent.On checking resource_view, path_view, user_xml_s ...

Oracle Ora-39014 error while export schema

HiThere is some tool to let me made a export of the database before try to install the patch. I have oracle 10g Release 10.2.0.1.0 What patch i need to install i gues is 8439220 ...

Oracle Ora-39014 error while export schema

I am getting this error with a premature exist of the job while trying to export a schema.Anyone know of a solution to this?The following is my system setup:Window server 2008 Standard SP1Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production ...

Oracle ORA-31693: Table data object "Schema"."Table3" failed to load/unload and is

Our database is on oracle 10.2.0.4.0 on Solaris and using Datapump to export the Data with full option.All of sudden we started getting the below error while export and export is getting terminated with the below error. Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROC ...

Oracle ORA-00904 error in DBMS_STATS.GATHER_SCHEMA_STATS

Oracle 9.2.0.5 on SolarisI am trying to run weekly stat gathering on a schema, using DBMS_STATI am getting this error on a specific table, wehich aborts the entire process:ORA-00904: "SEARCHKEYWORKS": invalid identifierthere is no such field. the table creator confirmed that initally he called a fie ...

Oracle ORA-20000: dbms_stats failing to analyze partitioned table

Our customer has two big tables in his schema : SCDASRFACTURES 20gb and SCDASRRELEVES 30gb.They are both partitioned by date. We are getting the following error when running dbms_statsSQL> show userUSER is "OPS$DOCUMENT"SQL> exec dbms_stats.gather_table_stats(ownname=> 'scdbre1', tabname= ...

Oracle ora-06550: dbms_stats.gather_system_stats must be declared (11g)

I am getting the error when tried to exec dbms_stats.gather_system_stats as system after creating 11g R1 database.Anything help is greatly appreciated.Gale ...

Oracle ORA-00942 when analyze, gather_table_stats, select

table object exist in DBA_OBJECTSas user system:select owner, object_name, object_type,status, temporaryfrom dba_objects where owner = 'SNEEZY' and object_name='tmp_BONUS_HIST';SNEEZY tmp_BONUS_HIST TABLE VALID Nbut:SQL> analyze table SNEEZY.tmp_BONUS_HIST list chained rows;analyze table SNEEZY.t ...

Oracle ORA-31223: DBMS_LDAP: cannot open more than 63 LDAP server connections

For my authorisation scheme (in an application that can possibly uses SSO) I created a function that looks like this:CREATE OR REPLACE function MAY_USER_VIEW_PAGE(P_PAGEID in number, P_USERNAME in varchar2) return booleanisVAR_USE_SSO varchar2(1);VAR_CONTENT_ADDER_GROUPNAME varchar2(100);VAR_CONTENT ...

Oracle ORA-31223: DBMS_LDAP: cannot open more than 63 LDAP server connections

For my authorization scheme , I used wwv_flow_ldap.is_member() function to determine if the :APP_USER is authorized to view a particular page. And it works fine until a few clicks this error occur after. Could anybody help me with this. ...

Oracle ORA-29532/DBMS_JAVA

we are doing migration of database from one hardware to another. We have a procedure which runs fine in the old instance and in the new instance we are getting the following error.We hava taken the database dump from old one and imported into new one as it is.Is there any grant is missingORA-29532: ...

Oracle ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials.

I have a process that is doing requests on the active directory. The problem is that when I specify the LDAP_USER (cn) and the LDAP_PASSWORD, I always have the error ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials.. I tried the account and it works perfectly on the windows login. ...

Oracle ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials

I'm trying to get some values from the LDAP server, I could authenticate againts but keep getting this errorORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentialsIf try to use anu LDAP function like getting attributes, ... If I use an ldap tool to search the server I could get the info. ...

Oracle ORA-01704 DBMS_SQL

I need to execute a very large sql statement and i try to use dbms_sql.parse with a varchar2s type statement. i save the staemte in a varchar2s variable, my statement lenght is 12900 characters long, but i receive the error ora-01704.i have no other choise ...

Oracle ORA-00904: "DBMS_XMLSCHEMA"."GENERATESCHEMA": invalid identifier

I am not able to use Oracle Package DBMS_XMLSCHEMA . I am getting following error.ERROR at line 1:ORA-00904: "DBMS_XMLSCHEMA"."GENERATESCHEMA": invalid identifierLooks like I do not have rights to DBMS_XMLSCHEMA.Do I need the rights to use the DBMS_XMLSCHEMA and which? ...

Oracle ORA-27475 - DBMS_SCHEDULER

what's wrong with the one below:Step 1create or replace PROCEDURE interface_stale_stats asBEGINDBMS_STATS.gather_schema_stats(ownname => 'INTERFACE',estimate_percent => DBMS_STATS.auto_sample_size,DEGREE => DBMS_STATS.default_degree,options => 'GATHER STALE');END;/Step 2/* Define a sched ...

Oracle ORA-23313 - DBMS_REPCAT.CREATE_MASTER_REPGROUP

I have a DEV database (db_name=DEV, instance_name = DEV, global_names=TRUE ) which was created from the backup of the database PROD. I am trying to implement replication between DEV and another database TEST. When I try creating the master group at DEV :BEGINDBMS_REPCAT.CREATE_MVIEW_REPGROUP (gname ...

Oracle ORA-00439. DBMS_STREAMS_ADM.ADD_TABLE_RULES

I try:BEGINDBMS_STREAMS_ADM.ADD_TABLE_RULES (table_name => 'strmadmin.employee', streams_type => 'capture', streams_name => 'capture_stream', include_ddl => TRUE);END;/And have the following error:ORA-00439: feature not enabled: Streams Capture ORA-06512: на "SYS.DBMS_LOGREP_UTIL", lin ...

Oracle ORA-31631 DBMS_DATAPUMP

I'm trying to datapump import a table from a schema to another schema in the same database. The code is something like the below:h1 := DBMS_DATAPUMP.OPEN(operation => 'IMPORT', job_mode => 'TABLE',job_name => 'IMPORT_EX1',remote_link => 'LOOPBACK',version => 'LATEST');DBMS_DATAPUMP.ME ...

Oracle ORA-00904: "DBMS_XDB"."GETHTTPPORT": invalid identifier

I am trying to configure Oracle APEX in oracle 10g.. while installation(Configure the Embedded PL/SQL Gateway) i got problem like as follows...SQL> select DBMS_XDB.GETHTTPPORT FROM DUAL ;select DBMS_XDB.GETHTTPPORT FROM DUAL*ERROR at line 1:ORA-00904: "DBMS_XDB"."GETHTTPPORT": invalid identifier ...

Oracle ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials

I have an application with LDAP authentication and a custom login page (pg 101). When I run this app, the login page displays first, logs me in and logs out fine. However, when I branch to this application from another application, the login page shows up with the following error:ORA-31202: DBMS_LDA ...

Oracle ORA-06512 at sys.XML_SCHEMA_NAME_PRESENT

I am using SQL Devp. When i am clicking on Other Users i am getting following error.ORA-00942 Table or view doesn't exists.ORA-06512 at sys.XML_SCHEMA_NAME_PRESENT Can any one of you please help me? ...

Oracle ORA-39125 & DBMS_METADATA

/* 10.2.3.0, 64-bit, RH Linux. */expdp user_b/password@happy2008 DIRECTORY=db_exports DUMPFILE=usra.dmp SCHEMAS=user_a LOGFILE=usra_exp.log When expdp-ing got this error (see below). Thing is that the DBMS_METADATA package is stored on the server, under the right (user_b) schema of the user running ...