Search results for query: *

Hi, I have written this query for a partitioned table and what I get is that it scans all the partitions, why is this so? SELECT COUNT(trn_no) FROM TRANSACTIONS WHERE ORG_CODE = :P_ORG_CODE AND DOC_DT BETWEEN ADD_MONTHS(TO_DATE(:P_YEAR,'YYYY'), -11) AND ADD_MONTHS(TO_DATE(:P_YEAR,'YYYY'), 1)-1...

hi, I get this error ora-000936, missing expression, when I run this insert statement: INSERT INTO MENU_USER ( MENU_ID, GROUP_ID, PI, PU, PD, CR_DTE, CR_USER_ID, UPD_DTE, UPD_USER_ID) VALUES ( SELECT MENU_ID, 'CODE2', 'Y', 'Y', 'Y', SYSDATE, 'ALEX', NULL, NULL FROM MENUS B WHERE B.MENU_ID =...

Hi, I added an extra index to a table however data inserted into the table can't be retrieved. There was already an unique index present. The index created is nonunique, could this be the reason?

I reformated a report with the result that its now faster and the message box for report's progress doesn't show the "Page break at next page" button anymore. Is there anyway it can be brought back. I have been requested by a user so that they can generate delimited files on a page by page...

Hi, I'm using reports 6i. I have a query with a formula column that I use to get values. The formula column has atleast 4 cursors and is used to update a place holder within the same group. [ main query ] | [ Column 1 ] [ Column 2 ] [ Placeholder1] [ formula column] [ ...

Hi, would like the steps required to restore and recover a datafile given: [ul square] there is no backup of the datafile the database is in archivelog mode archived logs exist from the creation of the database [/ul] I'm considering the scenario where the dba discovers that a datafile has...

How do I get a sessions session id (sid). I have tried using the following: SELECT sys_context('USERENV','SID') FROM DUAL but got nothing. Had initally opened 2 sessions with the same user, of which I wanted to trace one of them using the set_sql_trace_in_session procedure. Using select...

I'd like to know how to prevent a form from saving if a condition is true after a user presses the commit key (F10). I have tried adding this on-commit trigger at the form level but the form gets commited. declare update_after_approval exception; err_txt VARCHAR2(80) := 'Document is...

I recently changed my database from dedicated server to shared server. The problem is I can't connect to the server from another machine. I get this error: Enter user-name: /@pan as sysdba ERROR: ORA-12170: TNS:Connect timeout occurred I ran 'lsnrctl services' and got this: LSNRCTL>...

Hi, I can't connect as sys as sysdba using sqlplus 8.0.6 but I can using rman. This is the error I get: SQL*Plus: Release 8.0.6.0.0 - Production on Wed Sep 21 11:27:55 2005 (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter user-name: sys@test as sysdba ERROR: ORA-01031...

I've justed installed oracle on a unix production server and have noticed its possible to login from a remote terminal using 'conn / as sysdba' How can I disable this?

I'm reformatting a report and the block of the query has the following clause in the select statement: select fld1, fld2, fld3 from tabx WHERE 1=2 --<---- what baffles me is that it returns values when run from the form. How or from where are the values 1 and 2 being loaded or substituted?

I have a repeating group-based on a select statement with a outer join. This is so it always displays a default value. I have linked a repeating frame to the group but when the group returns rows where the default values occur nothing is displayed in the frame. The sql for the repeating groupis...

Is there any function that can be used to round to a number let say 100. I'm calculating a tax deduction, ded1, that is derived from a maximum deduction value, the percentage payable and a rounding accuracy (round_to_amt). For example: Given Maximum deduction = 400 percentage payable = 50% and...

There's a procedure called in before a before insert trigger that insert records into a table f_currency using a synonym p_currency, however on attempting to insert I get a primary key violation error in the f_currency's index. f_currency doesn't have any keys so I wondered how oracle created...

Am having a prob importing a dump keep getting this error IMP-00017: following statement failed with ORACLE error 604: "CREATE INDEX "EUL5_DHN_DBH_I" ON "EUL5_DBH_NODES" ("DHN_HI_ID" ) PCTFREE 1" "0 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 573440 NEXT 516096 MINEXTENTS 1 M" "AXEXTENTS 505...

Am using rpt2xls to export data from oracle to excel format, however am getting repeating rows in the output whenever there's a new page. The row of repeated references its data from summary fields within a repeating frame. The formatting code which does the actual export has been placed in a...

Is it possibe for an Oracle server to run in both dedicated and shared server mode? I've read that the mode is defined in the tnsnames.ora as below TEST.world = (DESCRIPTION= ... ) (CONNECT_DATA = (SERVER_NAME = TEST.us.oracle.com) (SERVER=DEDICATED) # <--- server mode ) )

Hi, am trying to edit a table with trigger that validates input. I have locked the table in share row exclusive mode but when I try to disable the trigger it hangs like its locked. am running all the commands from the same sql peompt. Is there a way to find out who is locking the trigger or table?

Is it possible to startup an instance without transacion recovery?