Hi Experts,
I want to pass table name as parameter to a PL/SQL Stored procedure which deletes all the rows in that table.
Is it possible to do so?
Or else do we need to go for dynami...
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 ...
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....
Hi All:
I have been trying to get Oracle 10g instant client running on my computer for hours.
The platform is Windows Server2003,it is running within a PC Client and the Oracle installat...
I have installed Oracle 10 G 10.1.0 on a computer where Oracle 9i (9.2) is already installet. I do not use Oracle 10G so much, only for testing.
Now I find that I cannot access Ora10.
Wh...
Does anyone know how to set a user variable to a value in a bind variable within SQLPlus?
For example, if I set up a bind variable like so:
variable today_date char(8);
Then, I s...
Hi,
we have here a server:
operating system: MS Windows NT Server
Oracle 8i
Same days ago the network administrator deleted all user-accounts of the operating system and created new ones...
I create a user in 10g, release 2 for windows:
CREATE USER abc identified by abc
default tablespace abc_TS1
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON TEMP
QUOTA UNLIMITED ON abc_TS1
A...
I have a 9.2.0.4 db server and the users is getting the following error:
Please advice in detail.
[1/16/04 16:03:34:717 CST] 2f8429b1 WSRdbXaResour E DSRA0304E: XAException occurred. XA...
I am getting this error when I run an asp.net app
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
What steps do I need to take to add a reference to the...
We have oracle server on UNIX machine and oracle client on Windows machine.
UNIX : Oracle server : 9i
Windows : Oracle client : 9i
When we insert a record with special characters ( germ...
I know how to startup Oracle database(connect sys as sysdba with sqlplus; startup; ) but I can do this only manually. What I want is to put this into a script that runs when the server boots. ...
Hi,
The prompt was this when started imp utility (not impdp):
Import: Release 10.1.0.3.0 - Production on Tue Sep 12 18:44:26 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
...
my sequence is just cycling two numbers?
SEQUENCE_OWNER SEQUENCE_NAME MIN_VAL MAX_VAL INCRE_BY C O CACHE_SIZE LAST_NUMBER
----------------- --------------------- ------- ----...
Hi experts,
our international company inherited a hudge system powered by Oracle 8.1.7 - Win32 W2K server installation.
There is a database created in headquarters which we have to use i...
What is the best approach to create a Oracle database using existing datafiles from different server?
I have a very interesting situation with Oracle export. We do a schema level export and it appears like it chooses conventional path on certain tables. I've checked the table and none of them ...
I have been tried to connect my DB (SID=WDH) by command: sqlplus system/system@dwh
after that, it orccured error so I COULDN'T resovle problem. System has a message "ORA-12523: TN...
I have a simple data block based on few fields of database table,
With each record I want to place a button which is enabled or disabled based on value of first field,
For example, lets say ...
I'm setting up in a newly created PC environment. I'm installing Oracle 9.2i. When it gets to the phase where it starts up the database I get the error in the title. I gave it a retry, same...
my database consists of different tables, i am trying to design a form as follow:
1. list item (this list item will be populated with player email addresses from player table)
player(p_i...
Hi there,
I am running two 8.1.7.4 databases on win 2k server's. One is the primary and one the standby.
I have recently created a repository for management console on the primary datab...
Hello,
I'm trying to insert a word doc into the database as a long raw. I'm not using Blob's because I can't return them correctly for the users with the application that we use.
I was ...
As you can see below heavy wait times on actually everything not sure where to start on this one, can anybody point me in the right direction?
Event Total waits Waits/s % total Total wait t...
Subject: EXP-00056: ORACLE error 4068 encountered
RDBMS Version: 9.2.0.4.0
Operating System and Version: MS Windows 2003 Server Standard Edition; 5.2.3790 Build 3790
Error Number (if app...
