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...
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...
Where can I download oracle form/reports 6i software from ?
I need it for windows 98 and I already have personal oracle 8i on my computer.
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'm getting this trying to ping a 10g database from a windows 2000 prof. client with the Oracle 9.2 Client....Do I need to re-install the client??
Message 3511 not found; No message file fo...
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 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.
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 ...
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 ...
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 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...
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...
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!
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...
I'm a database developer who needs to connect to both Oracle 9i and 10g servers. Which client software would be the best version to use on my development workstation? Are the 9i/10g clients cr...
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...
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...
I am attempting to insert into a table using NEXTVAL. Here is my code and I am getting an error that the sequence doesn't exist, but I thought this was an Oracle standard that would work. An...
My data looks like this
sale_fact table
customer_key site_key week_key
1 100 375
2 200 376
2 100 ...
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...
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?
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...
Hello,
I need to present date differences (interval?) in years, months, and days instead of just days. I'm looking to do this in simple SQL (instead of Java, PL/SQL, etc.) on the other han...
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...
OracleDBConsole Service Does Not Start
After starting up without any problems following a recent install of Oracle 10g Standard Edition on Windows 2000, the OracleDBConsole%Oracle_SID% (Or...
