I have a full export for my development databases and one of the development databases export is failing.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
With the ...
Hi,
OS : Solaris 9
Oracle 9.2.0.5
My objective is to move an index from one tablespace to another.
alter index <index name> rebuild tablespace <tablespace name>
It fails with ...
Hello...
I'd like to know if there is a way to set up a DBA "Read-Only" User Account. Crazy question I'm sure. The reason is that there is another office in this company I work for that has a...
When I try to export my database I get the following error:
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
Could someone help me resolve this iss...
I have installed oracle xe 10g on my windows 2000 adv server oracle tried load there was a problem loading the page I am using firefox and Ie6 it will not load
Firefox can't establish a c...
I type the following to export:
exp owner=tems_adm file=/tmp/tems_adm_orig.dmp indexes=y constraints=y rows=n log=/tmp/tems_adm_orig.log
But at the end of the export I get these errors:...
I accidently set a parameter to an invalid directory. I shutdown the database before I realized it. When I tried to start the database again I got an error that the parameter in question has a...
Dear All,
I am using the following software and versions.
----------------------------
Report Builder 6.0.8.11.3
ORACLE Server Release 8.0.6.0.0
Oracle Procedure Builder 6.0.8.11.0...
Hi,
I have a Oracle 9.2.0.4 db server.
I am trying to make a full backup.I run into the below mentioned error.
Any help is appreciated.
Thanks
Error at the bottom:
About to export ...
Hi,
Oracle 9.2.0.5 on solaris
Application is J2EE through application servers with connection pooling.
During stress testing, a large number of sessions were created. Though for last fe...
I ran the utlrp.sql after installing a patch on my database and one of my objects came back as invalid.
How would I fix this? The object in question: UTL_RECOMP
First of all, I can't seem to create a materialized view containing self-joins AND union all. Is it possible?
I checked Oracle 9i (my version: PL/SQL Release 9.2.0.4.0 - Production) docume...
Hi,
Is there a way to manually set an oracle 9 database system date without changing the Operating System date? and If there is a way, what are the ramifications from doing so?
Thank yo...
Our company is new Data ware house using OBIEE.My job will be supporting the final product and generating the reports and answers from it. So i am planning to take up some training.
I trie...
Hi ,
I need to enable oracle xa support for my 9.2.0.6 database. I think that for that ,at the db side 2 scripts need to be run right?
ie. initjvm.sql and initxa.sql. what is the order h...
To create additional databases I have used a script file using external commands in Oracle 8.1.7.
As such svrmgrl have used to run sql scripts.
ie:
spool c:\oracle\ora817\admin\MYDIRC\c...
In a pre-insert trigger I would like to be able to quietly abort the insert under certain conditions. By quietly, I mean without causing an Oracle error such as when using RAISE_APPLICATION_EX...
I recently installed the 9.2.0.4 patch on a Oracle 9.2.0.1 database. When using SQL*Plus, I am now receiving a "SP2-0310: unable to open file "filename"" when trying to access any files forme...
Similar scenario to previous post: Oracle client on Citrix terminal server, but did not see information there to resolve the issue.
Sunblade platform, solaris 8, oracle 10g r 2
I am seei...
Hello,
I am OCP... that was enough introduction for me...
now going directly to question....
First look at the part of the script that i m using for creating a sample database...
P...
I have tnsnames.ora file in two places, /etc and $ORACLE_HOME/network/admin. So how can i find which file is used by tnsping or the sqlplus client to connect to the database. I The $TNS_ADMIN ...
i have an oracle 9i and i copied my controlfile to another disk location after shutting down the database and changed my init.ora file to include the control file location. when i started orac...
Hi
I am using SQLPlus script to pull data from a table and spool to a text file. The app I need the spool file for expects certain data in the first line, which is gotten from the table by...
Hi,
I am using vb.net to update an Oracle Db. The update statement keeps generating an ORA-00972: identifier is too long error message.
Any idea whatÂ’s going on?
For Each Row In Ds...
I have a calculation in my WHERE clause:
((((a.SALES_PRICE - a.UNIT_COST)/a.UNIT_COST)*100)<15)
That throws an "divide by zero" error that I need to handle.
I was trying to use a CASE...
