Dear Sir/Madam
I have installed oracle 11g onto linux (centOS) and it works fine. But everytimes I reboot linux (centOS), I need to start the database (test) manually.
Why is this happens?...
Need a quick answer - what is the maximum number of records that SQL Server 2000 can handle, SQL 2005 and Oracle 11g
Thanks
I am very new to the Oracle and now trying to connect Oracle DB from Crystal report.
Some suggest use JDBC, some Suggest use ODBC, which one is better and
I tried ODBC and always get er...
Subject: Create db 11g now creating and starting listener give tns-12560
RDBMS Version: 11.1.0.6
Operating System and Version: Windows 2003
Error Number (if applicable): TNS-12560 and TNS...
Whenever you set the column to the number type in an Oracle database, then you have to set the data precision and scale, what are they and how they can affect the database?
I just installed Oracle 11G and am not able to locate the GUI SQL Plus. When SQLPlus.exe is executed, it brings me to a DOS based version of SQL Plus. Is there a way I can get the GUI veriso...
I want to install sysstat-7.0.0 RPM in order to install Oracle 11g where i can found the right RPM for my distribution
Hi,
Can someone please tell me the best way to call a remote web service from PL/SQL using Oracle 11g
Cheers
I was trying to install Oracle 11g on Linus SUSE in dell machine. when i run the installer file ./runInstaller, server through an error : java: xcb_xlib.c:52: xcb_xlib_unlock: Assertion `c->xl...
Hi,
This error has been bugging me for sometime now and I can't find a straight forward answer anywhere, can you help?
Oracle 11g on Windows XP SP2 Intel box.
I am trying to export da...
Hi Guys,
Based on the illustration I have below:
OWNER OBJECT_TYPE OBJECT_NAME
------------------------------ ------------------- ----------...
I am trying to find a simple way to keep two fields the same at all times, but all the samples I come accross are more complex than what works in DB2 (we are migrating to Oracle).
Hi i am onstalling oracle 11g database enterprise edition on windows xp and during the pre-requisite check I get the following error. How do i fix it for where the test has failed?
Checking...
Hi Am new to Oracle.
Ive installed and configured Oracle 11g Server in Oracle Enterprise Server 5.
Ive started necessary services and I was able to log in to SQL Plus from the server.
N...
I have an existing database that was created by someone else. I want to view the check constraint properties of a couple of columns. How can I do this via command?
Does anybody know how to uninstall Oracle 11g from Linux? When I installed Oracle 11g I used the command ./runInstaller. This opens a copy of OUI and I ran through the process. The instance...
Hello experts,
I open SQLDEVELOPER GUI and try to connect to Oracle (host); but I am getting a network adapter issue... any ideas how I can troubleshoot this?
thx
I have pulled up selected records using the select statement below. I would like to now delete those rows from multiple tables. I know the SQL statement for delete is
delete from <table> w...
Hi all,
I'm using UTL_TCP to provide FTP functionality through Oracle and have set up ACL privileges for my Oracle user to connect to another server.
I create a connection specifying por...
Hello Experts,
I have install Oracle 11g on centOS 5. Now,
I am installing Oracle instantclient_11_1 on a separate machine, winXP.
Here are the install procedures: (from Oracle docs):
...
i m getting Following Error
1 CREATE OR REPLACE procedure BASE_USER.create_audit_table (i_table_name in varchar2)
2 is
3 begin
4 execute immediate ('create table base_user.a...
Experts,
Trying to create a new database; however, getting messages:
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted
what is the issue and how do I resolve it.
...
Is there any way in an oracle compound trigger to save the bindvariable :OLD or :NEW to a variable of type [table]%ROWTYPE ?
I have also tried to generate dynamic code (EXECUTE IMMEDIATE), bu...
Hello Experts,
I need to be able to connect to Oracle 11g server (tower) from my laptop. I am losing my mind. Please help.
Please see server configuration below, am I missing something?
...
Experts,
I cannot access my Oracle Enterprise Manager. I get an error Address not found. firefox can't find the server at localhost.localdomain_orcl. I was able to access the db fin...
