Hi
Does SQLPlus store the connect string (or host string). Eg I connect as: conn myname@myserver, is there any way of accessing the "myserver" value from within SQLPlus?
Thanx.
Hi All,
I modified the password of SYS user using another user account with DBA role. However, when i try to login using SYS as SYSDBA, i get the error message "ORA-28009: connection to sys...
Hi,
I get this message when I try to connect to an Oracle databse. (Oracle version: 9.2.0.1.0)
The listener.ora and the tnsnames.ora seem OK, tnsping works.
What is the problem?
femo
Oracle Forms builder 6i: Unable to see stored procedures in data block wizard and therefore use data block wizard.
Facts:
Data block wizard can be successfully used to build blocks fo...
I am trying to apply a CPU patch on my windows Oracle Database. I keep getting opatch errors related to Java:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp...
Dear Experts,
I am looking for detailed differences between the two types BLOB and CLOB. I will appreciate, if you point me to any resources on the internet or answer the question yourself.
...
Greetings,
I installed Oracle 10g Grid Control software on a Sun Solaris Sparc Server and everything installed successful but I am getting this error when I attempt to set my side and the o...
Got this error closing a Statement object - what does this error below mean??
java.sql.SQLException: Protocol violation
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
...
Hi All,
I removed the redo01.log, redo02.log and redo03.log files of our Oracle database. And it caused the db to fail. Is there any way I can recover the database? I do not need it to have a...
Oracle 10g on AIX with 6 started databases locked up. Users in session could continue processing but no new users could sign in. SQLPLUS froze after password was entered even when trying to ...
We have got a problem on a Dynix system with ORA-01019 started happening
The Oracle documentation is not very helpful
Is this an appropriate place to look for help?
How do I increase the buffer size so that I will stop getting the following errors during import?:
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the...
I have one problem left with my sql when calculating a time difference. Assume EndDate = 03/31/2009 02:00:47 and BeginDate is 03/31/2009 02:00:46. I should get 1 second. I am getting 00:00...
Why can I not connect to SQLServer?
HSODBC a Oracle database link with SQLServer.Credential retrieval failed. Failed to make RSLV connection.Lost RPC connection to remote Agent
I am running ...
i have the following error on my alert log
ORA-12012: error on auto execute of job 137
ORA-00001: unique constraint (GMAPP.GM_PHS_ORG_PK) violated
ORA-06512: at "GMAPP.GM_POPULATE_APPLICATI...
I have tnsnames.ora file in two places, /etc and $ORACLE_HOME/network/admin. So how can i find which file is used by tnsping or the sqlplus client to connect to the database. I The $TNS_ADMIN ...
The Problem: When attempting to run dbstart I receive an "Insufficient Privileges" error.
The Pertinent Information:
- Database: Oracle 9i, Release 2 (9.2.0.1.0)
- OS: Red Hat Lin...
I exported a table in a dump file as DBA from a windows environment. I need to import that dump file into a Unix environment as a user who is not a DBA. How can I enable the user to to import ...
Hi
I have just installed Oracle Database 10g express edition, and the installation seemed to go well.
I then select to go to the database home page after the installation which opens a b...
Hello,
I have a problem accessing an Oracle instance remotely.
I have two Linux computers, one is running Oracle 10g database server,
the other has Oracle 10g client software installed....
Can someone point that what new included in 10g with developer point of view. Also I want to discuss here that there are three cd's for the oracle 9i while only one for 10g. Is there some copo...
I have a query in oracle:
query = "SELECT * FROM REGIONS ORDER BY To_Number(RID) DESC";
will the same querry work in mysql and sql?
is there a way to find out ORACLE_HOME directory
using just SQL commands?
I m using Oracle 8i and win2000
I am creating hot backup script for my oracle database( archive log mode), my script logical as attached, but I do not know how to copy data file when you are in backup mode inside sqlpus, say...
A report should count some entries by week since beginning of year. To simplify
the question let's assume that the first calendar week starts on Jan 1. The way
I put it together is more or...
