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...
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?...
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...
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...
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...
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?
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...
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...
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...
I am trying to write a Procedure for my Oracle 11g server to grab a set of table entries to return to a C# application, and update a bunch of values in the table entries. Essentially, I have a...
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
We have run the program "Wyse Generate and Print Quote" using "Quoting Sales Manager" Responsibility Just for your reference we have run the "Wyse Generate and Print Quote"
program request id...
How to add an increment number in the result in Oracle.
Suppose I have a select statement to select all order numbers, as below
0001
0001
0001
0001
0002
0003
0003
0004
0004
How ...
Hello everyone. We currently have a 10g database which we are preparing to implement streams on. Is it worth it for us to upgrade to 11g first? In other words, what enhancements does 11g st...
Hi,
I have an old Oracle installation running since 1998. I have an UNIX-HP-UX Workstation with Oracle 8.0.5 Database. The Clients are running on Windows machines. Some processes are running ...
Experts,
I am installing Oracle Clusterware for the first time and i ran into the following errors.
What kind of privileges does the user need to install, as you can see from the error mess...
What would the best character set be for a new data warehouse in Oracle 11G.
The considerations are:
-Application supported charactersets (for example Cognos, Business Objects will report ...
Can Oracle 11 client run/connect/access an Oracle 10 database server? I would think it would easier for an Oracle 10 client to access an Oracle 11 server but I just wanted to be sure.
I have no idea how this work
http://www.oracle.com/technology/oramag/oracle/05-mar/o25dba.html
anyone can give me a VERY SIMPLE example for me and make me understand how the following stat...
Hi,
I am looking for a comprehensive guide to Oracle streaming.
Thanks.
Hi i have a user whenever he uses IE to browse the internet he is not getting any iexplore.exe messages. However when he tries to use IE to go to a Oracle sms application server forms page tha...
I am profroming the install of the Oracle 11g database on Win 2003 R2 Server. I have kept
all the default settings (Oracle Home etc.) . On the last protion of the database install when it ...
I have loaded oracle 11g stored procedures scripts that were modified. How do I retrieve the code from the compiled scripts so I can modify them again.
I am not that familiar with oracle...
How to add a column in Oracle?
How can we specify the position of the new column?
We have the following in MySQL
alter table abc add column my_new_column varchar(100) after old_column;
...
