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?
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 a view in Oracle using the result of a stored procedure as parameter in the where clause.
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...
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.
...
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...
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...
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...
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...
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...
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...
Is there a way to query an Oracle 8i database to get a list of all users with DBA role?
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...
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...
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_...
Hi there,
I am receiving the following alert to my inbox "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01". I have researched and it looks like I need allocate space for...
Every time a user is leaving an oracle-based application open without using it for several minutes or half an hour they get "ora-03114: not connected to oracle"
what could be the cause of t...
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...
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 am installing oracle 8i software in my latop which uses windows vista os. Pl let me know how to install it.
Hey Pals.
I created a DBMS job in Oracle. This is the first job that is being created on this database.
When i look at all_jobs view, next_date and interval..etc looks fine. But the job does...
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...
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...
I am new to oracle,
DBA has just granted me priviledges to view procedures, but i don't know command to execute: See DBA comments below and please tell me proper commmand to view stored proce...
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...
