oracle 8.1 database has date column but it shows time portions also, when we update the field there is necessity to update this field with custom time stamp, is that possible to do?
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...
I have a problem that a computer´s OracleServiceORCL will not start. Neither the OracleOraHome81Listener.
This happened when the computers hard disk was starting to get full, and the netwo...
I want to create/replace the materialized view but i got the following error
ORA-00922 - Missing or invalid option
CREATE OR REPLACE MATERIALIZED VIEW payroll_mvw
REFRESH ON DEMAND
AS SE...
Is there a way to force Oracle to always use a specified index. The hint does not guarantee this.
Is there another method? Below is an example where I want to use the specified index. Howe...
In my oracle 8i database, I need to find out (on the fly) if users have "write" permissions to certain tables.
Is there a way to use a query to find out what permissions a user has for a tabl...
Using Oracle 8i
I have a query that returns 3 columns col1, col2, Time_Diff from myTable as shown below. Time_Diff is the difference between a date column (col3) in myTable and SysDate.
...
On Thursday, Feb 14, at about 8:20 - 8:30 pm, pacific time, the partition holding archive logs filled up completely so the database staooped processing transactions. The space that was availab...
We are getting following error on our oracle(Release 8.1.5.0.0) based application. Could somebody advise, how we can recover from this.
ora-01578: oracle data block corrupted (file # 3, bl...
Using oracle 8.
I am using the following query in an oracle function but I want to know if it could be written better. I have a table "my table" which has two sequence numbers "sequence_no" a...
How to create stored procedure in oracle for select statement?
Hi All,
I'm looking for a way to convert a Calendar week number to date range.
Example:
Calendar Week Number = 2
What I need to return is something like 1/4/09 to 1/10/09. If thats ...
I want to create a view in Oracle using the result of a stored procedure as parameter in the where clause.
Hi,
In Oracle 8, how can I get the hex values of the contents of a column and row in a table?
there is a certain column of a certain row of a table that has a strange character stored. I...
Is there a way to query an Oracle 8i database to get a list of all users with DBA role?
Dear EE member,
I would like to spool the following in csv format:
set echo off;
set feedback off;
set heading off;
set verify off;
set linesize 80;
spool /home/oracle/testdata/test...
Hi Guys,
Easy one. Looking for an Oracle equivalent to selecting two columns and putting it into one, such as the following that would work in SQL Server:
Select last_name+', '+first_...
Hey everyone, hope you can help with this.
In order to provide the business with an overview of the quantities of data in various tables in the database, and how close they are getting to t...
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. Successful...
I am installing oracle 8i software in my latop which uses windows vista os. Pl let me know how to install it.
I have a column which has date/time. I want to the query to only show records in the past year from the date run (using something similar to getdate in MS SQL). I am using MY SQL, but I thin...
I have an Oracle 8i (8.1.7.4.0) database. I would like to know how I can send SMS from the database to our customers. We have a business need whereby we would like to send SMS to customers who...
I have query which is returning rows in ascending order wher i am doing ...
select to_char(insert_dt ,'MM/DD/YYYY') as insert_dt from table
order br insert_dt desc
This query returns da...
which is the fastest way to insert millions of records from one table to another in oracle 8i (8.1.7.3)?
And which is the fastest way to delete millions of records from one table in oracle 8i...
Hi Experts,
I'm using Oracle 8.1.7 on Solaris 9. Currently, to export tables, there's a script do this as below (only part of them, this is to export all tables):
$ORACLE_HOME/bin/exp BU...
