Hello all,
Here is the original SQL statement that did not need OUTER JOIN functionality, very basic all INNER:
SELECT DISTINCT
a.group_id,
a.workorder_no,
b.assignment_no,
d.docume...
hi experts:
in our ERP system, there is a table ( table name: NOTATION ) in which one column named NOTE ( data type LONG RAW ).
SQL> desc notation;
Name ...
I want to connect as sysdba to an instance EARTH (there are 3 instances running on the Win machine)
"sqlplus sys/syspass@earth as sysdba" does not work from cmd..
I do not want to do it inte...
I have seen several posts describing how to export Oracle tables to flat files using scripts, programs and various other "techy" approaches. I am not an Oracle DBA, but need to export Oracle ...
Hi,
I'm new to Oracle DBA stuff, and have been attempting to install an Oracle 9i database on my machine. The installation was sucessful, however I think I may have mucked something up in ...
Hi,
I get this message when I try to connect to an Oracle databse. (Oracle version: 8i)
The listener.ora and the tnsnames.ora seem OK, tnsping works.
What is the problem? when i restart o...
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
Hi,
I would like to know the EXE to startup and shutdown Oracle 9i database from command prompt (MS-DOS). I know in earlier version of Oracle (8i), there is an utility SVRMGRL to start orac...
Hi,
Ijust installed oracle and when i connect to it and issuing and alter session command i get the error message ora-12705. During installation i chose the default NLS xter which i normal...
I have some data in an oracle table that I need to clean up.
Here is a sample of the data from a text file before it was loaded into an oracle table via sql loader (I have 10,774 records in...
i have an view owned by sys.
when i try to give execute privileges on this view to an user.it gives an error
ora-04063 view has errors.
i tried to recompile the view and than it gives th...
i have various oracle 9i installed on windows2000.
some of my servers are at my same location(for e.g A) and some if them are located at a different location(for e.g B.) we use a lot
of dat...
How to fix this?
ORA-01653: unable to extend table xxx by xxx
tablespace has 12 Gb free space
table next extent is 100K
alter tablespace xxx coalesce doesnt help
any other ideas?
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...
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...
I am trying to increase my shared_pool_size and java_pool_size. When I try to increase my shared_pool_size I get the following errors:
ORA-02097: parameter cannot be modified because specif...
Hi All,
My server has been installed with Oracle 9i.
In order to extend the life of this server for further 5 years, do I need to consider upgrade this database to a new version (e.g. Or...
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 am about to install patch 5490846 and I am unclear regarding the instructions. Should I run root.sh, catcpu.sql and then shutdown the database before I type opatch apply? Or should I Shutdow...
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 ...
Hi!
I want to convert a LONG data-type column to char/varchar when i provide a view for my view user. Any comments/suggestions are highly appreciated...
Thanks in Advance,
Regards,
U...
This is a two-part question.
I have a partially restored database where I have some new, and some older datafiles. Together I have them all. No archivelogs, no anything. This is the path...
I have downloaded your free version of TOAD 9.5 for oracle After installation it
asks me to input the authorization key. Could you please advise where and
how to get the key. Thanks.
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...
