Hi,
I want to extract the bd-live in the following string. can you please help me to write the query in regular expression or substr/instr functions
20081203-v1-was_bd-live_20081...
After recovering the DB, I got an error saying that:
ORA-01173: data dictionary indicates missing data file from system tablespace
TRACE FILE shows:
OSWITCH archival processing for an...
folks
i have 3 fields in table 'LABTRANS' ( id,date,hours)
how do i show a decode statment to sengment the hours per day of week ie
ID DATE HRS Mon Tue Wed Thu Fri Sat Sun
1 23-5-8...
Current setup is We have a Novell E Directory were users details are located. we also have Oracle internet directory . replication of users details from novell E directory to oracle i...
I use Oracle Colalboration Suite and When I upload any file or to create any folder on Content Service, an error occurs on Content Service
2008/06/16 10:29:58 [oracle.ifs.ecm.agents.MostRec...
Is it possible to suppress creation of redo during Materialized View refresh. The M-Views are defined as NOLOGGING (as is the Temp tablespace), but massive amounts of redo are generated anywa...
Hi,
I am working on development of Messaging Hub which will store the accounts and contacts data received from client system.We are storing Objects data as objects internally and storing th...
Good Morning All (well depending on when you read this):
Typically in the past, I've had people create the Oracle tables for me and I just interact with them. The current project I've had t...
Greetings to all,
I am very new in Data Migration and I have to migrate an ADABAS Database to Oracle 10g.
I need to know if there are tools or are their any options for easier migration ...
insert into ORDER_PROCESS(ORDER_ID,CSSINSTID,BUYERID,ORDERTYPE,PROCESSTIME,SYSDATETIME,IPXML,OPXML,IPSTAA,OPSTAA,JOURNEY,ORDERSTATUS,REQUESTORDERTO,CAD) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
t...
Hello,
I have installed Oracle10.2.0.1 in F:\oracle\product\10.2.0\db_1 directory using OUI. I then patched it to 10.2.0.3. I then tried created a database using dbca. The file environment ...
Hi Experts,
I have few questions on Oracle 10g...
1) As a dba, is there any view to check the privileges of the users? As as user, i can check the privileges using session_privs table. A...
I am using Oracle 10g R2 and the ODP for .Net version 10.102.3.0
When I was running this application as a fat client app (C++ using the 8.1.7 OCI library), I kept up to 200 (shared) handles...
Hello everyone and happy new year,
I would like to create a job in order to shutdown my database in oracle for an amount of time and then starting it up again. I was thinking to create 2 jo...
How to convert a monolith table on Oracle 10g into a Partitioned table?
I am running windows ulitmate with oracle 10g XE. I installed oracle 10g xe without problems.
Id like to know where the docs directory for the integrated web server is. I can go to http...
<FilteredEyeData>
<ExtinctionRatio Units="dB">12</ExtinctionRatio>
<EyeCrossing Units="%">111</EyeCrossing>
<AveragePower Units="dBm">12</AveragePower>
<Jitter Units="ps">23</Jitter>
...
I am using Microfocus Cobol and in my program i use the datatype as COMP-2. I want to know the data type which oracle supports to the precision of the COMP-2 . I get a error saying 'Invalid nu...
I am exploring the Oracle Database Configuration Assistant on a 10G install on my Windows XP machine. I am trying to learn something about database administration. In step one of using the a...
Solaris 10
64-bit Oracle 10g (10.2.0.3)
I'm trying to change the filesize of a particular tablespace file to 32GB, and I am having problems doing it. Are there filesize limitations on th...
Can any expert make clear what is host in oracle..
Select /*+ RULE */ R1.*, Rownum from (Select Distinct h.Company Company,
h.Doctype Doctype,
h.Docno Docno,
h.Custpo C...
Hello,
We are testing migrating our standard RMAN backups to use the IMAGE COPY method as the backup windows on some of our systems are too long.
According to the Oracle docs (and our te...
Dear experts,
We've developed an application running on Windows XP XP3. The application reads a set of files and continuously runs SQL-Loader to load data from these files to Oracle databas...
hi,experts
now i have i table mytab like
pid name column1 column2 column3
1 tom a1 b1 c1
2 ...
