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
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 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...
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 Guys,
Based on the illustration I have below:
OWNER OBJECT_TYPE OBJECT_NAME
------------------------------ ------------------- ----------...
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,
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...
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...
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?
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 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).
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?
...
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 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...
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...
There is a view with many columns (a few hundrends), while one of them is row_id.
See code below.
I need to retrieve a single row ( by row_id) and display its columns and values as rows, l...
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.
...
Hi,
I'm very new to Oracle so please be gentle?!
Here goes..
Installed Oracle 11g on windows XP with fixed IP address. No errors reported.
Can connect from client using browser to Ente...
