why Oracle is saying my sub partition does not exist when I can clearly see it?
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
SQL> SELECT table_name,
2 partition_name,
3 subpartition_name
4 FROM user_tab_subpartitions
5 WHERE table_name = 'DAY_NETWORK_AGG'
6 AND subpartition_name = 'P_USER_1_P_201302010000';
[code].....
ORA-14251: Specified subpartition does not exist
This is what I used to create the table and I have yet to put any data in it, so I am wondering if Oracle doesn't really create the subpartitons from the template until there is actual data.
I have a SQL query with a construction like: select a, b from tablea ,select * from (select a as a from tableb) where ....
The issue is that in sqldeveloper I don't get any errors and the select works fine.I use the same select in myEclipse report builder and I get an table or view doesn't exist.
I have query in which having some issues with outer join.When I run the inner query, I am getting 121 rows and when i put outer query and run it, I am getting 69 rows coz the code_combination_id does not exist in the outer query table.But even when I say ( + ) , its not giving 121 rows..
I create a range-list partition table using the subpartition template,and there is a default subpartition p_default,when i insert a row which provcode values is 6 into the table,and it belong to the default subpartition,how can i spilt it into a new subpartition such as p_6, and make the row belong to the subpartition p_6?
create table tb_hxl_user_split ( statedate date not null, provcode number not null, usernumber varchar2(13) not null, rem1 varchar2(1024), create_date date, create_by number, last_update_date date, last_update_by number [code]....
I have the following problem on a 10.2.0.4 Oracle on AIX 1.6..I have 2 RAC nodes as the node # 2 goes down, the VIP migrated correctly to the node # 1, but the listener # 1 do not see the change, and just resolve to the local ip.
The same does not apply in the reverse case, when it drops the node N 1, the listener attends to the fallen VIP node and migrated.The configuration is correct and identical in both nodes, according to the documentation, but I can not find a reasonable answer.
IP node # 1. scm1or01 192.68.60.11 scm1or01-VIP 192.68.60.13
IP node # 2 scm1or02 192.168.60.12 scm1or01-VIP 192.168.60.14
when scm1or02 is down: scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin> lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 11-APR-2012 19:56:46 Copyright � 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER_SCM1OR01 Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production Start Date 11-APR-2012 16:50:19 [code]...
I do not understand the reason, I've rebuilt the configuration of the listener, and netmgr netca tools, but the problem persists
My applications is integrate with Excel 2003 by Ole2 package. Some of them excel books are using functions activates with Excel Complements (activate with men options: Tools-Complements-Analyisis Complements and Analysis complements VBA).
The problem is when I invoke this excel book in Oracle Forms, this functions don't work.
I am using Oracle 10g and when i start my server then my database is running and my application use this database.But after 15 min automatically application show this error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
I was working on an applications program It is written in PL/SQL . It is running on an oracle 8i database It was not written by me but now I am responsible of it. I made some changes to database tables for this years regulations. Everything was working fine but yesterday I have recompiled two of the packages for some regulations and one of the procedures was stopped working.
It is called 'sayfa2'. Packages names are 'aday1' and 'aday2'. They both have a procedure called sayfa2 and both of them don't work now. They gave me no compilation errors. All I did is I have copied the original code from toad and compiled it at sqlplus I have changed nothing except some texts inside html tags. I couldn't guess what is wrong.
It actually converts to html pages. All procedures are working fine except sayfa2. aday1 is for to fill information and submit but when I click submit button it gives an error:
The requested URL /pls/kon/aday1.sayfa1 was not found on this server. Oracle HTTP Server Powered by Apache/1.3.19 Server at ...
There is also a problem with Turkish characters they don't appear correctly.
Below is sayfa2 and I also added aday1 package could you have a look at it .
PROCEDURE sayfa2(stuid VARCHAR2,tckimlik VARCHAR2, ad VARCHAR2, ad2 VARCHAR2, soyad VARCHAR2, sex VARCHAR2, mdurum VARCHAR2, bad VARCHAR2, aad VARCHAR2, dyer VARCHAR2, dgun VARCHAR2, day VARCHAR2, dyil VARCHAR2, nil VARCHAR2, nilce VARCHAR2, nkoy VARCHAR2, cilt VARCHAR2, asira VARCHAR2, sira VARCHAR2, asuba VARCHAR2, kang VARCHAR2, agorev VARCHAR2, [code].......
I have a master block (MASTER with Item 1 and 2) and details block (DETAILS). If the user enters the query mode and queries the Master block, the Details get populated automatically. So far so good.
Now I attached an LOV to Item 1 in the Master Block and the requirement is that when the user picks an item in the LOV, the details should automatically populate. Because of "restricted procedures" (GO_BLOCK) in triggers, I put a Button in a Control Data Block and the code in the WHEN-BUTTON-PRESSED trigger is as follows :
GO_BLOCK('DETAILS'); EXECUTE_QUERY;
It does go to the Details block and also displays all the details. However, when I try to update, insert or delete data, it fails with "Insufficient Privileges". So when I looked at the query being executed (Cntrl + Shift + E), I can see that it is trying to perform these operations on the Master block. (ie for some reason the scope is still in the Master and not Details even after Go_Block(DETAILS) has been executed.
I then tried to use Go_Item('DETAILS.Dept_No') to see if that would work. That too did not work. I tried to set the Navigation Style on these Data Blocks to "Change Data Block". Still no success.
I'm trying to create a view that includes both custom and delivered tables. The SQL code produces the desired results in SQL Developer. However, when I create and test the view using that code, I get very different and incorrect results. The SQL part of the view is below:
SELECT j.emplid, pt.deptid, pt.y_policy_id, pt.effdt, pt.title, pt.comments, pt.y_policy_covg, pt.doc_url FROM psoprdefn a , ps_job j , ps_y_policy_tbl pt WHERE substr(a.oprid,1,1) = '0' AND a.emplid = j.emplid AND j.job_indicator = 'P' AND j.effdt = (SELECT MAX(effdt) FROM ps_job WHERE emplid = j.emplid AND empl_rcd = j.empl_rcd AND effdt <= sysdate) [code]....
I have a stored procedure which has varchar2 as IN and sys_recursor has OUT parameters.
CREATE OR REPLACE PROCEDURE check_values ( my_values IN emp.dept_no%TYPE, p_cursor OUT sys_refcursor )
[Code]....
/The problem I am facing is in where condition, if I give quoteValues it doesn't fetch me any records when I execute the procedure from sqlplus, but if I am giving my_values it does fetch me records. I am receiving IN parameters like 9856,9712,8723, so first I put single quote around the emp_no and pass that to where condition.
i've a problem regarding my code at line: 76. URL....
If i put a RAISE_APPLICATION_ERROR just before: SELECT ID_GIOCATORE INTO CONTR_GIOCATORE2 FROM COMP_CONTR_GIOCATORE_PARTITA GC JOIN CONTRATTO C ON GC.ID_CONTRATTO = C.ID_CONTRATTO WHERE GC.ID_PARTITA = :NEW.ID_PARTITA AND (C.ID_CASELLA = 28 OR C.ID_CASELLA = 12) AND C.ID_CASELLA <> :NEW.ID_CASELLA AND [code]....
But if i put the RAISE_APPLICATION_ERROR just after this statement and before IF(CONTR_GIOCATORE2 IS NOT NULL AND CONTR_GIOCATORE2 = CONTR_GIOCATORE) THEN, nothing happens after the insert(that goes well) and the trigger doesn't do his job(insert,update etc). if i do that select, i got the no data found, so i put the exception to set the variable CONTR_GIOCATORE2 to NULL.
However, I'd also like it to return any product that doesn't have a TEST_UOM_GROUP, for example the 'Bud'.I've hit a brick wall and just keep going around in circles and not acheiving the result I'm after!how to either change the SQL Query.
I have DevSuite 10g on my XP. Running a form from frombuilder, for testing or debugging purposes for example, always worked. I am using OC4J.Now we moved the DB-User, to which I normally connected in the above scenario, to another DB-Instance, but left username and password unchanged. I changed my connection in formbuilder to the new destination and formbuilder succeeds when connecting to the DB. Compile etc. all ok.But running a form from formbuilder raises ORA-01017. After that, the forms logon screen is shown and has exctly the username and ORACLE-SID defaulted with my connection in formbuilder itself (only username is "upper"ed).
So apparently the formbuilder connection information or oarts of it is passed to the runtime. When I then give the password in the logon screen connecting succeeds. How is the connect information from formbuilder passed to the runtime?
I've installed oracle 11.2 in Windows 7 - 64 bits. Everything was working fine until suddenly stops working. Oracle Service (OracleServiceORCL) doesn't start and when I try to start manually, returns OS error 1067. Listener starts well. Below I list my listener.ora, sqlnames.ora and sqlnet.ora
oracle 10G who knows why Oracle SQL doesn't support %TYPE when create a table. But it supports it when we use it in PL/SQL.
SQL> create table wg_1 (account_category JNL_WORK_LIST.ACCOUNT_CATEGORY%TYPE) ; 2 3 (account_category JNL_WORK_LIST.ACCOUNT_CATEGORY%TYPE) * ERROR at line 2: ORA-00911: invalid character
SQL> desc JNL_WORK_LIST Name Null? Type ----------------------------------------- -------- ---------------------------- ACCOUNT_NO NOT NULL NUMBER(10) BILL_REF_NO NOT NULL NUMBER(10) BILL_REF_RESETS NOT NULL NUMBER(3) JNL_EARNED_THRU_DT DATE [code]...
Name Type ------- -------------- ID NUMBER(8) USERID NUMBER(8) SORT_TEXT VARCHAR2(100) TEXT VARCHAR2(1000) DATE DATE VALID VARCHAR2(1) CODNEW NUMBER(10)
The table has a normal index for the userid column.
There is a query that looks for the differents CODNEW for a USERID but allways the CODNEW has to be greater than 2248833
select codnew from news-comment where userid=2914655 and valid='N' and codnew>2248833
I have created a new index for this kind of querys
create index coment_new_IDX on news_comment (CASE WHEN codnew >2248833 and valid='N' THEN userid ELSE NULL END )
but oracle doesn't use it. I have used a hint to force it but doesn't run.
I am running Ubuntu 13.04. I am attempting to install Oracle XE 11g R2. It seems that everything was fine until I got to configuration of the database as root I ran /etc/init.d/oracle-xe configure command. I have received the following output Starting Oracle Net Listener...Done Configuring database...
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details
When I look at the logs I get the following error ORA-01034: ORACLE not available. After receiving this error I have attempted to start Oracle manually.
sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 3 11:34:07 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ORA-00845: MEMORY_TARGET not supported on this system
As you can see I got
ORA-00845: MEMORY_TARGET not supported on this system error. Ok let's see what's going on with my partitions
