Hi,
I have created a complete image of a windows server 2000 machine with an oracle database using symantec system recovery 8.5, however when i restore the image of this server to either an...
I have this problem:
ORA-1654: unable to extend index ARTS02.CTRA_DUP_IND by 512 in tablespace REUSE_INDX
I am not good at fixing it and I am looking for help
The server h...
Dear Expert,
I request your assistance in designing a schema for the following:
A parent company is having 5 subsidary companies.
However, the employee details for the parent company and ...
how to change sql prompt in oracle8i.
for example in dos we change "prompt" command to change current prompt according our wishes.
like that,
what is the command in oracle to change sql...
Here is just a sample for single table export (however, the goal is to export data from very old database for two owners). Catexp.sql has been run (there are some ORA-01921 error in it I hav...
Hello,
I'm working at a company where Oracle 8i was installed 5 years ago (Oracle is just used for 1 little program the engineers use). I've never worked with Oracle before. Recently, I'v...
Hello, I'm trying to query data for a report, but not all records are coming through. If s.name has a value for gas_prod but no value (null) for alloc, it will not return the row. I would like...
Hi I am new to Oracle and an experience SQL user.
I need to scope out an Oracle system and look at tables and sample data with the view to export into SQL via text files.
Please can some...
I have two database environments. One if oracle 8i and the other is 10g
when i run the following query in 8i it returns as follows (see below)
8i
SELECT rownum, TYPEID, name
FR...
In an attempt to have a "working" backup server... I need a script to export /import the db structure from 1 server to another...
What I mean is :
I have now a running oracle 8i server DB ru...
HI ,
I am trying to install oracle 10g rac using vmware on my laptop. I have dell studio with 6 GB RAM, 64 bit t6400 core 2 duo processor and Vista as an Operating system.
I was just won...
I have a query that has a column which is a formula that divides one field into another field to get a result. The result column is formated as a number 0.00 and what I'm trying to do is show ...
Hello expert
what is the difference between module and package in linux?
AND
What is the purpose of symbolic link and how do we create it? Can you plz elaborate a bit
I have an application build in ASP & Oracle. sometimes Application runs very nice but after say every 2 hours we need to reset iis because some of the pages abnormally give an error and it say...
I want to change the Oracle application standard login logo image to something else. But I cannot locate where the image is.
It seems the image name is "oracle_logo.gif"
Anyone knows ho...
I just installed Oracle 8i into a Windows 2003 Server. The installation gave me some trouble because the java JIT, and the Network configuration got freezed. after install i ran Net8 Assistant...
Hello Gurus,
I am to maintain a Oracle Application 8.1. that is not supported any more by the application developer.
Since I am the IT there , so I have that burden...
I cloned my server...
Hello there,
if someone could help me please.
I am trying to figure out howto backup and restore oracle data base 8i on NT 4 box then restore it on different NT 4 box with the same Oracle 8i...
Please review this code.
I need the o/p in a csv file,How can i achieve it.
(note:The table have some blank values for few columns)
Thanks
can I use "set" command in pl/sql in oracle8i?
Hi all,
Assignment Question here, now I've done the most part I should speak to my lecturer however he doesn't have time.
So here goes, I understand without a stored procedure one cannot...
Hi I am trying to create a table from another table (source table). The source table has dates with date and time. I want my table to only contain the date only (no time). I am running this...
