Hi,
I have a batch file that I want to connect to a specific database and run administrative sql statements.
I tried running the following script but only get to the SQL> prompt. H...
Hello Everyone,
Please disregard the version i stated earlier it is in fact Oracle 10.2 that i am using
I'd like to thank everyone before hand for any assistance provided. I am trying to ...
EXECUTE IMMEDIATE'TRUNCATE TABLE TEMP_AUTORACK_FLAG';
EXECUTE IMMEDIATE'DROP TABLE TEMP_AUTORACK_FLAG';
EXECUTE IMMEDIATE'CREATE GLOBAL TEMPORARY TABLE TEMP_AUTORACK_FLAG
(AUTORA...
How to implement creating a new column on a existing table with the default as sequence.next_val
And ... not using a trigger
Hi friends
We have recently migrated from 9i to 10g database. And we are testing applications.
While inserting into one of the table we are getting error. End of communication channel
ORA...
SQL>
SQL>
SQL> PL/SQL procedure successfully completed.
SP2-0734: unknown command beginning "PL/SQL pro..." - rest of line ignored.
SQL>
SQL>
Hi I am getting the following error while trying to install the runtime repository. Any idea how I should proceed with the troubleshooting?
Thanks.
C:\oraclexe\app\oracle\product\10.2.0\server\BIN>net start OracleXETNSListener
System error 5 has occurred.
Access is denied.
C:\oraclexe\app\oracle\product\10.2.0\server\BIN>net star...
Hi,
my Oracle system has crashed badly so redo logs are corrupt. It is a development database so data is of no importance.
What I want is to just use the database server again.
Due to red...
Experts,
This is an urgent request. I need compare the colume of datetime type (e.g. 06/21/2008 11:30:00pm) with a timestampe like (e.g 06/21/2008 10:40:35). what is quick way to do that?...
experts,
i ran one database script from os(unix) using nohup. i got unix process id. now i want to check the status of
my script in the database. how do i check it.
i want to find orac...
HI Experts,
How to find out which object/rows are locked using TOAD?
i mean how to monitor?
HI,
I have a few administrative commands I need to run against 3 different Oracle databases on the same instance. What is the syntax to connect to each db and execute commands via bat...
Hi All,
I have a specific table (called "arcustflds") in an Oracle database that I want to pull into a text file. I've been told that SQLPlus can do this. Does anyone know what the SQLPlu...
I'm trying to install the DBD::Oracle module for Perl. I'm doing this through the command line on a Suse Linux box.
First I enter: perl -MCPAN -e shell
Once the CPAN shell comes up, I...
I have the following code, I am attempting to create an array variablr to hold various data:
DECLARE
type t is table of number INDEX BY BINARY_INTEGER;
I get the compiler error unexpec...
The attached code is part of a stored procedure, which is where I'm getting the eeror.
Max cursors is set at 1024 and I just can't see how I'm going anywhere near that.
thanks for your help.
I thought I should be able to reference a column alias in the where clause in Oracle (9i) SQL.
However when I try
SELECT account_num AS test FROM account
WHERE test > 999;
I get "ORA...
Recently purchased an ERP system that uses Oracle 9.2.0.6. The system includes a data dictionary and an interface to write SQL scripts. I would like to write 2 SQL scripts:
1. Script tha...
Hi,
We have 3 RHES servers (V4.6) - the DBA would like Oracle RAC ASM on all 3 servers
access a common NetApp SAN raw disk partition.
We found that /dev/mapper/mpath1 on server 1 is /...
I originally set up a user HSS with the following table spaces (HSSDATA for data and HSSINDEX for the index tablespace). Later I wanted to change tablespaces. So I ran the following sql code f...
I have a slightly different problem, but along the way I got the same error. A dba-in-training was attempting to do some partition maintenance on one of our largest tables yesterday. It has 90...
Hi,
Our outsourced developer has given up on using /dev/mapper/...
to set up Oracle RAC ASM as they ran into problems with one
RAC server (on RHEL 4.5) could see/access the ASM partitions...
Hey I'm super SQL saavy but not so much oracle saavy. I have Oracle XE installed and I'm trying to restore a .dmp file that someone sent me. So I open up the Run SQL Command Line utility and l...
Hi
when I try to execute a procedure which will select data from table1 and move data to table2 I am getting this error message
ORA-01843: not a valid month
NLS_DATE_FORMAT ...
