Hi All,
My client is having problem with restoring the .dmp file where their database already crashed. The .dmp file is 6gb and there is no way to open the file because its showing memory i...
Hello,
I had Oracle 8.17 installed on a server. Then I uninstalled it, and the reinstalled it. When I installed it, it works fine. But now I have a problem. If I stop/ start the service the...
is any way to recover system datafile on NOARCHIVE log?
- backup file too older
-the recover database not solving
-the recover datafile not solving
-the corrupted block seems not allocated...
Hello,
We are in the process of moving dbfiles of four 8.1.7 databases to one filesystem on Solaris. Instead of the database files locating in diferent mounts they are all being relocated ...
Hi Support
Please let me know how to recover in a situation
1. catalog crash
2. target database crash
3. backupset is available on tape.
Regards
Kailash
I am trying to duplicate a database on a different host. We have been doing this once a week for quite awhile and now we are getting an error.
Can anyone give me an idea of what might cause ...
Hello experts,
I'm having some problems inserting numbers with commas (5,15) into my oracle db. I am located in Europe so this is standard. When I try to insert the number I get a 'invalid nu...
Hey, I just started learning oracle because the database at my place of work is not functional and the person who set it up has left. That being said I don't know much about the way it's set u...
Hi,
I have cursor with a complex inline query, used inside the procedure. when the complile and excute the procedure its working fine in oracle 9i Database.
When i try to run this in the...
Dear Friends,
I am trying to drop a view in oracle 8i, It giving me error:
ORA-08102: index key not found, obj# 38004, dba 25175635 (2).
I think my data base block has been corrupted.
...
I am getting error as follows when i try to schedule job
SQL> variable v_JobNo number;
SQL> BEGIN
2 dbms_job.submit(:v_JobNo,
3 what => 'exec DBMS_UTILITY.ANALYZE_SCHEMA('HR','ESTI...
I use DATABASE LINKS on my reporting database, against each of several other Oracle 8i databases. All of the database links are working fine... except one.
Many of the databases, includi...
The disk with my oracle instillation and datafiles is almost full. How do I go about moving the database to a different drive. My oracle skills are pretty limited so if you could go pretty slo...
We are upgrading from Oracle 8.1.7 to 10.2.0.1.0 we currently use this command in Oracle 8;
SELECT MAX (EXTENT_ID),SEGMENT_NAME FROM DBA_EXTENTS
WHERE OWNER LIKE 'OWNER_NAME%' AND EXTENT_I...
Running Oracle 8i on windows 2000 server.
I would like to shutdown and restart one of my instances but am not sure which one is shut down. What I've been doing is logging in as sysdba and r...
Suppose i have 50 - 100 records in Emp Table, i need to select any 10 records at random, without mentioning any criteria. how can i do this.
actually i will do this from a form in VB, but you...
I'm using Oracle 8i database. I have a table name Staff which have field Username.
In this table let say I have 3 records - Jack, Bob and Amy. I can display the record
using SQL query with...
We are evaluating migrating a Sun Solaris installation with a Sunfire V480 @x900 with 8GB memory and two processors to an Intel Red Hat environment. The systems is running an Oracle 8 Applicat...
If I run the following sql I get a result set with one column and several rows
SELECT FIELDNAME
FROM PSRECFIELD
WHERE RECNAME = 'JOB'
ORDER BY FIELDNUM
I want to change this so I get mu...
Is there a script I can run that lists all users and all their privileges, roles, schemas?
Oracle 8i and 9i on AIX
Hello,
I've reinstalled the oracle. The oracle works fine, the queries are fine but if I do joins with large tables the queries are very, very slow. Is a problem of tablespace free space?
...
I have Questions Table in oracle 8 with Fields and data type of each filed mentioned as below that stores questions, 4 options for answers and correct option.
Questions
QuesId, Number(...
I use IDBS ActivityBase software that uses oracle. When adding data to the database via ActiviyBase I get a ORA-00001 unique constraint violation. I would like to see specifically what sql sta...
We had successfully rename datafile from one location to another. Everything is fine. The disk space is not released until I rebounce database (even though I can see the file is not in old l...
Database version 8.1.7.4
I'am creating an index to a table that has 85 partitions.
The script is failing with Ora-1555 snapshot rollback segment too small.
The perso who made the database...
