Experts Exchange Search Results

Hi experts, I am trying to migrate from 8.1.7 Oracle DB on an E450 server (Sun OS 8) to 10.2.0 Oracle on V880 Server (Sun OS 10) I have installed Oracle 10.2.0 and created an initial DB using t...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23473735.html

Zones: Oracle 10.x, Oracle, Oracle 8.xDate Answered: 06/19/2008 Grade: A Views: 0

Error: ORA-20 (There are a lot of connection inactive)

Tags: ORACLE, ORACLE, 8.1.7

Hello everybody, I've Oracle 8.1.7. There are 155 connections but 100 are inactive. The program that uses the oracle is a 16 bits program. The program fails because there is the error ORA-20. ...

http://www.experts-exchange.com/Database/Oracle/8.x/Q_23499240.html

Zones: Oracle 8.x, ServersDate Answered: 06/20/2008 Grade: B Views: 0

ORA-12514 TNS:listener does not currently know of service...

Tags: Oracle, Oracle, 8.1.7

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 data...

http://www.experts-exchange.com/Database/Oracle/8.x/Q_23562421.html

Zones: Oracle 8.xDate Answered: 07/16/2008 Grade: B Views: 273

If I do a list with a lot of large tables, are very slow.

Tags: Oracle, Oracle, 8.1.7

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? Be...

http://www.experts-exchange.com/Database/Oracle/8.x/Q_23562944.html

Zones: Oracle 8.xDate Answered: 07/16/2008 Grade: A Views: 0

rename datafile does not release disk space

Tags: oracle, rdbms, 8.1.7

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 locati...

http://www.experts-exchange.com/Database/Oracle/8.x/Q_23727028.html

Zones: Oracle 8.x, Oracle 9.x, Oracle 10.xDate Answered: 09/17/2008 Grade: C Views: 9

I've been deleting rows. But It has been stopped. Now the...

Tags: Oracle, Oracle, 8.1.7, Archivelog On

Hello, I've been deleting some rows with SQLPLUS with a transaction. Then the oracle was very very slow. I've restarted the server but the server is very slow. What is the problem???? Is the a...

http://www.experts-exchange.com/Database/Oracle/8.x/Q_23553878.html

Zones: Oracle 8.xDate Answered: 07/14/2008 Grade: B Views: 0

How do roll back my database to a previous time

Tags: Oracle, Oracle8i enterprise, 8.1.7

I am adding entries into my database soon, this does not happen often at my place of work. I would like to make sure that in the event that the data entry does not go to plan I can rollback my data...

http://www.experts-exchange.com/Database/Oracle/8.x/Q_23777995.html

Zones: Oracle 8.xDate Answered: 10/01/2008 Grade: B Views: 13

Automate Oracle Restore Using Online Snapshot of DATAFILES, ...

Tags: Oracle, Oracle 8.1.7, 8.1.7, oracle 8 on hpux 11

I am trying to automate a nightly Oracle restore using a daily snapshot backup (online backup) of DATA FILES, CTL and REDO LOGS. I'm able to run everything OK, however, I'm stuck on recovering th...

http://www.experts-exchange.com/Database/Oracle/8.x/Q_23194467.html

Zones: Oracle 8.x, Oracle, Oracle 9.xDate Answered: 06/28/2008 Grade: A Views: 25

ora-01033 oracle initialization or shutdown in progress

Tags: Oracle, Oracle 8.1.7, 8.1.7, Activating standby database

Hi Experts, I need to activate my standby database at DR in order to restore a table that was previously destroyed at primary. I had restored COLD backup a day before the incident. Successfully di...

http://www.experts-exchange.com/Database/Oracle/8.x/Q_23288654.html

Zones: Oracle 8.xDate Answered: 04/24/2008 Grade: A Views: 211