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...
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,
I am running Linux Red Hat Enterprise Server 5 and Oracle 11g 11.0.7.0 (patched) in VMware Workstation 6 on Windows Vista.
I already have 1 db instance installed called orcl that ...
hi All,
I used one tablespace called CDR_space to save table tbl_CDR include data and index. This table has a huge records, about nearly 50 milions row. But after I delete table data, the ta...
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...
Experts,
I need to connect to the database instance in Oracle 11g. I'm getting an error Failed to Connect. cant' establish a connection to the server at localhot.localadmin:1158
...
Hello Experts,
I am having problems with my listener. It does not know the service name; but I do see it and need it.
I am configuring it (and reconfiguring it) via ./netca and/or ./netmgr...
INSERT INTO CustomerFamilyHistory (customerfamilyhistory_id_seq.nextval, firstname, lastname, age, ?????, sibling, customerid)
SELECT customerfamilymemberfirstname, customerfamilymemberlastn...
How to install Oracle 11g in Ubuntu 9.0.4 64 bit version?
I have downloaded the zip files linux.x64_11gR2_database_1of2 and linux.x64_11gR2_database_2of2 from the Oracle website.
I have unzi...
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...
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...
Hello,
I am developing a form for one of our clients. As a part of this developement I need to insert a record into HZ_PARTIES table using the API
HZ_PARTY_V2PUB.CREATE_PERSON.
I am t...
Anyone able to confirm Oracle 10g and 11g is certified on Windows 2008 64bit platform?
I created some sequences. I would like to indulge into the primary key column in CREATE TABLE script. How can i do it?
Hi,
I have an Oracle 11g instance that I am unable to connect to when I reboot the system. Prior to rebooting, it works fine. Following a reboot, when I go to log in via SQL Plus I get th...
OS: RH Linux X86_64
DB: 11.1.0.7
Storage: SAN w/64k page size.
What does Oracle recommend as far as running disk defragmentation utilities on the database mount points?
Our SA set this ...
I have a 32bit Application running on a Windows 2008 64 bit server using Oracle V11 32 bit client. I am publishing it to a Terminal Server and it works OK using Remote Desktop. I published...
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.
Experts,
I have an Oracle 11g database on Windows 2003 on a VM hypervisor. Yesterday morning we the listener was down. I started the listener and then started the database, no probl...
I ran the code below to set up utl_mail on our database. It succesfully created the package and public synonym for utl_mail.
I'm logged on as sysman and I can browse the schema in Toad and s...
WHEN I TRY TO CONNECT TO CONNECT
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
xdb always require user and pwd
then i found in this url...
I have installed the 11g thick client on my desktop and i do not see Enterprise Managel Console. I choose the Administrator option while installing which should give me the EM Console as well....
Hi
I have installed Oracle 11.2 Grid Infrastructure (standalone) on RHEL 5.3 64-bit
After I changed hostname of the server I cannot connect to ASM instance.
I am getting the following e...
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;
...
