I have following issue in our database. I Checkted the tablespace have enought space to grow but till its complaing with error blow
ORA-1683: unable to extend index SYSMAN.MGMT_METRICS_RAW_...
Dear Friends,
I'm using XEClient for Orcale 10g and I need to reach a Oracle 9i data base on the server, where can I put tnsnames.ora in XEClient?
Thanks in adnvance!
Jose Luis
I need to duplicate a table, what is the fastest way?
Our customer is currently using ISQLPLUS as a workaround in order to perform SQL functionality through a web interface. We've upgraded the majority of their databases to 10g and they've been ...
I need to create a view that selects fields from a table. but I need 2 of the fields to appear as 1 field. I want to use the concatenate feature. What would be the syntax for doing that?
Hello everyone...
due to a waste of space during inserts on my ORACLE XE I reached the maximum limit for a datafile where now I have almost 5Gb of a file... I already did a ALTER TABLE ......
I am trying develop a report in Oracle Reports Builder. The report is grouped by Action Number and Action because there may be more than one action office (etc) for each action. The layout i...
Hi,
We will be doing upgradation Using DBUA.
Is there any document to upgrade OneSAP Oracle DB from 9i to 10g. Database is around 2 terabyte.
I would like to know how many man hours it wil...
I need to setup something like SQL server log shipping for my Oracle 10g database. I have the PRODUCTION oracle server hosted at a co-location. We have a secondary server at HQ with an oracle ...
Ok, difficult to word this in the best possible way.......
Going into Oracle Enterprise Manager 10g - Application Server Control through this link
http://oracle-oid:18100
Shows the li...
My question is I am unsure how to proceed providing storage for RAC. Here's some background to help understand my confusion. I have a newly purchased 3-Dell 2950's and an EMC Clariion CX-10 (w...
Hej Alle,
I am trying to do something like following
Update Table A SET A.Column1 = B. Kolumn1 WHERE A.ID=B.ID
A is the table to update and B is the table to match on.
Plz help
I did the following procedure for back up .
after that how can I restore the database..
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> c...
Hi
Our application is migrating from mysql to OCCI.
we have an issue with performance and got the comments below to try to apply it
===============================================
Note...
Current setup is We have a Novell E Directory were users details are located. we also have Oracle internet directory . replication of users details from novell E directory to oracle i...
How can i determine the frequency that statistics get generated on tables. I have found that tables get auto analysed at diffrent times and get out of date. What controls this? How can i guara...
When working with international languages we noticed that some characters are uppercased differently in java and Oracle 10g. I.e. chr(223) or "ß" in Java becomes "SS" when toUpperCase is appli...
How can I clone Oracle software from one server to another server.
Unfortunatelly, the ORACLE_HOME for the source and the target servers are different:
Source server: /oracle/sid1/102
...
I have a table with following fields and the key to the table is a
combination of first 3 cols.
table 1
ID VARCHAR2(11 BYTE) NOT NULL
recno NUMBER(4)NOT NULL
Date DATE NOT NULL
U...
my host name is MATHEW-B8F381B1
I GOT THIS FROM
select host_name from v$instance;
MATHEW-B8F381B1
AND ALSO
>IPCONFIG
IS 192.168.1.106
I TRIED BOTH WAY TO START TO START ISQLPLUS
BUT...
I recently installed ODT for .Net: version 11... I'm creating an app in vb 2008 express. The app was working. I had to reboot because of a hang with another app. After reboot, the app doesn't ...
I'm a newbie with Oracle. I'm a SQL Server DBA.
I need to configure a replication topology.
We have 5 Oracle 10g Database servers: one server in the corporate headquarters and one server in ...
how to write Sql Loader script to load date field into table date format is "dd/mm/yyyy" or mm/dd/yyyy"?
But default date format for oracle 10g is "dd-mon-yyyy".
Experts,
i am getting this rman error. could you please help me what is going on
channel dev1: sid=1069 instance=UMGPRD2 devtype=SBT_TAPE channel dev1: VERITAS NetBackup for Oracle - Rel...
I have had an issue with Oracle starting properly at startup. When I access the Enter prise manager I get error "Error :ORA-01034: ORACLE not available". When I try using the Recovery Setting...
