I'm looking for the easiest way to remove a database (Test1.domain.com) and it's files from the Oracle server since we need more space. I have access to SqlPlus and Oracle Enterprise Manager.
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23408276.html
Zones:
Oracle 9.xDate Answered: 05/16/2008 Grade: A Views: 0
I have two tables with relatively disparet information. I want to join these two tables together to form a sequence of events. This hould be easy, but I can't seem to get the query right.
Ora...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23418166.html
Hi,
I have an Oracle8(8.0.6) database.
I want to upgrade it up to 9iR2.
What is the "best" upgrade path ?
Via IMP/EXP, or just patch it to the new version ?
Please give me your advises.
...
http://www.experts-exchange.com/Database/Oracle/Q_21412075.html
Zones:
OracleDate Answered: 05/09/2005 Grade: A Views: 0
In Oracle 9i I has created a database that works great when its the only database on the server. Is it possible to put 2 Oracle 9i databases on the same server. Andf if Yes, What are the steps to ...
http://www.experts-exchange.com/Storage/Storage_Technology/Q_22498940.html
Hi all
I have been given a folder contains the following files types for a oracle database and as i have never used oracle before, what would be the quickest option to restore the databases, ba...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23273676.html
Hi,
I have an oracle 9i database running at home under RHEL 3.
Somehow, one of the redo logs got corrupted, and now the database will not open properly.
BTW, I have no backups.
I logged in...
http://www.experts-exchange.com/Database/Oracle/Q_21367441.html
Zones:
OracleDate Answered: 07/13/2005 Grade: A Views: 19
I have a full export from .dmp file of my database. I just found out that a table that needs to be in the database is no longer there. I would like to know two things. First I would like to know...
http://www.experts-exchange.com/Database/Oracle/Q_23122598.html
We are currently experiencing an increased I/O bottleneck on our database server. The database is waiting on disk read/writes and redo writes (all these wait events point to I/O contention).
I've...
http://www.experts-exchange.com/OS/Unix/HP-UX/Q_23075550.html
This is my first post I hope this is enough Information.
We are running crittically low on one of our SCSI drives in the server.
Has anyone successfully cloned a hard drive that contains oradata ...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23379208.html
When I run the attached code with a not equals operator in the where clause like:
and pvs.vendor_site_code <> 'DSSI'
instead of
and pvs.vendor_site_code = 'DSSI'
the query fails with the
E...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23682649.html
