i downloaded a freeware for toad. and i gave my userid/password.adn database name.i am not able to connect to it. i get ora-12154 tns:could not resolve the connect iddentifier specified.
an...
Hi,
I want that my regular users don't "su - oracle" on linux before starting sqlplus.
In other words I want to grant them priviledges to start sqlplus without loggin as "su - oracle" onto u...
Hello Gurus,
I need help with the following SQL and for the life of me I can't find the right syntax.
CASE WHEN aa."ENTITY" LIKE 'A%' THEN 'E'||LTRIM(aa.ENTITY, 'A')
I need to further d...
I am setting up a 2 node RAC cluster on Solaris 10 (sparc)... I have 2 nodes... bart and moe... when I run the cluvfy command to check the configuration I get the following back... and ideas.....
I have just recently upgraded computers and consequently my Oracle installation from 9i to 10g. I used to use the SQLPlus Worksheet, but it doesn't look to have been installed. I also looked...
Hello,
we want to migrate a database from one server to another. It's a dev database.
To consolidate the structure we want to move several users with their tablespaces and datafiles all ...
Hi, I use this scripts to display the data file usage, will someone verify is this suffcient to check on data file properties and space usage?
SET SERVEROUTPUT ON
SET PAGESIZE 1000
SET LI...
experts,
i got one problem with my database. i am getting this error while i am executing one package. please find the error message.
ORA-29278: SMTP transient error: 421-4.3.2 Connectio...
Hi!
I am new to Oracle installations, starting with this job last month and learning. I have successfully installed the application database on one machine, the Oracle Identity Management (...
Hi Experts,
I need to restore 4 tables for our oracle database. I have got a export dump file of the whole database backup. Can you please tell me how can i restore those 4 tables from the ...
Unable to connect to the Oracle dB after joining Server to the domain.
Able to connect when the server is a member of a Workgroup.
Steps performed:
Created Oracle's password file
init.or...
I'm trying to put together a Data Pump Export but I get the following error message:
[oracle@oratest oracle]$ ./datapump.sh
Export: Release 10.2.0.2.0 - Production on Monday, 25 Jun...
Hi!
I am administrating two Oracle 10g Release 2 databases, although I am more a software developer with little administrative experience. I also made the installation of the DB one one mac...
Hi!
I have installed the Oracle Database 10g and the OIM. Now, I want to install the application server 10g. During the installation, I am asked to "Specify OID Login". The dialog suggests ...
Hi,
I am trying to install Oracle 10g Enterprise Edition on my laptop (Microsoft Windows Vista Home Premium, Sevice pack 1).
I pass all but one of the prerequisite checks apart f...
Hi
I have a stored procedure that uses the XMLQuery function (SELECT XMLQuery( '......' RETURNING CONTENT) FROM dual; ) to extract data from 3 different tables and store the xml file in XML...
Setup: Suse Sles 10 Linux 64bit version. With Oracle 10g R2 (10.2.0.3) April 2007 CPU patch applied. Controlled with Oracle Grid Control 10.2
-----------------------
-----------------------...
I am using oracle 10g on windows server 2003 64 bit. I have a datafile I am trying to resize but it keeps giving me the error:
ora 03297 file contains used data beyond requested resize value...
I am looking for a way to import an excel spreadsheet into the oracle database / table. What is the best method and what would be the quickest method to achieve this.
I corrupted my spfile when I modified a param through oracle enterprise manager ( I assumed it was ok to do this). I got the database to start up as follows.
[oracle@linux3 ~]$ sqlplus "/as s...
Hi Experts.
I am getting error while executing the following SQL statement in Oracle 10g
-------------------------------------------------------------------------------------------------...
when i try to read a file using UTL_FILE.GET_LINE i get ORA-29284: file read error but when i read the same file using UTL_FILE.GET_LINE_NCHAR i don't receive any error, but my "Ñ" character i...
Hello,
Can you recommend the steps to install Oracle Express Edition (XE) and the latest version of Application Express (APEX) 3.12 on a Windows system?
I am NOT looking for a bunch of p...
I am trying to create an Oracle Stored Procedure in 10G for a search page.
My problem is I do not know how to do a check in the where clause for Null parameters being passed in.
When a ...
