|
|
Browse by Tags
- 10
- 10.0
- 10.2
- 10.2.0.3
- 10.2.0.4
- 10g
- 11g
- 6i
- 8i
- 9i
- access
- another
- backup
- between
- blob
- change
- check
- Client
- clob
- column
- command
- connect
- connection
- convert
- create
- crystal
- Cursor
- data
- database
- date
- db
- DBA
- delete
- difference
- error
- excel
- export
- file
- format
- forms
- from
- function
- get
- how
- import
- index
- insert
- install
- invalid
- java
- jdbc
- join
- Linux
- listener
- long
- multiple
- number
- odbc
- Oracle 10g
- Oracle 9i
- Oracle Database
- parameter
- password
- PL/SQL
- procedure
- query
- RDBMS
- report
- reports
- rman
- rows
- schema
- script
- select
- sequence
- server
- service
- session
- size
- slow
- solaris
- sql
- sqlplus
- start
- statement
- stored
- string
- table
- tables
- tablespace
- toad
- trigger
- unix
- update
- user
- using
- view
- vs
- windows
- xml
-
ORA-09925: Unable to create audit trail file
Today I got a strange error while connecting to SQL plus using sqlplus "/as sysdba" The error was ORA-09925: Unable to create audit trail file Linux Error: 13: Permission denied Additional information: 9925 ORA-01075: you are currently logged on I exited and tried connecting again to sql plus... -
ORA-01152: file 1 was not restored from a sufficiently old backup
I am getting the following error RMAN> alter database open resetlogs; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002:... -
Oracle sql question
I have this table employee id name dept id status 12 tom 11 A 14 Tim 11 C I should not get record back if any one of the dept_id has a C on it select * from emp join dept using (dept_id) where status!= 'C' This give me a record .. what I want is if the dept_id of 11 has any 'C' then I... -
ORA 1000 maximum cursors useage
Hi Experts i received a database from customer which cause ORA 1000 error. the number of cursors is increase by the application. the same application on another database there is no problem. the open_cursors of Init.ora file is the same=300. i want to find out the differents between the databases concern... -
Query Result
I have 2 tables ... Table A - PkId , OldRefID, NewRefID 22 , 123 , 124 23 , 445, 490 .. .. Table B PKID , Col1, Col2, Col3 123 , 4, 5, 6 124 , 56, 67, 88 445, 9387,433, 333 490 , 33, 4556, 222 As you can See Table B's PKIDs are same as OldRefID and NewRefID of table A. Or in other words each of teh... -
Need some SQL expert help with JOINs to multiple tables
So I've been tasked with building some reports based on the Oracle SQL data, however I'm testing my sql queries in Oracle SQL Developer and I've been banging my head against the wall over this query. My query is below: 1: 2: 3: 4: 5: 6: select DC_ACTION_EVENT_ACT.CODE_CRT_LCTN, DC_CD_COURT_LOCATION... -
How to check whether any record exists or not
What is the best way of cheching whether a record exists or not? I am doing as below in my function but it is giving error. i am not sure what mistake I am doing. lv_lock NUMBER := 0; SELECT 1 into lv_lock FROM logical_lock WHERE LOCK_RECORD_TYPE_CD =826 AND LOCK_RECORD_ID = (SELECT DOCUMENT_ID FROM... -
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Hi experts, I get the following error when I want to start sqlplus: [oracle@localhost ~]$ sqlplus Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory [oracle@localhost ~]$ For more information, tnsnames.ora is as follows... -
inserting date/time in to oracle table
Hi all, I am trying insert a record in to oracle table from cold fusion mx.One of the fields is a date/time field.It gives me an error.Below is the code.Please help. YY HH:MM:ss")> Insert into table1(name,ssn,datesubmitted,email) values('xxx','xxx-xxx-xxxx', TO_DATE('#submitdate#'... -
Shell Script - Sql Loader Issue
Hi Experts, I ran into one strange situation while executing master script from crontab scheduler. We have a Solaris as a UNIX flavor, shell scripting using korn shell and database is oracle. I have a master script which will do sub tasks in orderly fashion. One of the sub tasks is SQL loader which loads...