Hi,
I need to install Oracle 9i on Ubuntu 7.04. I only have SSH access to the box, and all the instructions I find describe a X based install process. How can I work around this?
oracle 9.2.x
HP-UX
1)how to find out if a database has rman backups configured?
2)please give detailed steps to setup rman configuration for a database.i am under time pressure and couldn...
Hi! I need to perform an update on a table that contains around 10.000.000 of record.
What I have to do is write an sql script that performs this operation, using a rownum, to perform commit...
Hi,
Can we import .dmp (Oracle exported) files with installing oracle on the machine. Are there any tools for this?
If no, while importing the .dmp files on a Oracle installed machine it...
Hi everyone,
How to use an array as a stored procedure parameter?
I need to pass several arrays as parameters to Oracle 9i stored procedure.
A sample with a brief explanation would be...
I am new member just joined this exchange group hoping to get some usefull solutions. My question is: we are upgrading all our Oracle DBs to 9.2.0.8.0 from 92040/92060 etc.. I would like to k...
I am using the Legato Single Server version with the Oracle9i to take backup on tapes. But my RMAN is not able to communicate with the Legato Network.
Experts, I have a newbie Question regarding ROWID
I am new to Oracle and I am picking up where someone left off and this person isn't here to ask any questions. I have this query that takes...
Hi!
I try to use the RMAN DUPLICATE method for creation of copy of my db but are running into some issues.
I have created an auxiliary instance on a secondary host machine. Starting it, trou...
We are using TOAD 9.5.0 with Oracle 9i and have not run into problems until now.
We created a procedure in Oracle PL/SQL that calls a function. This process can run without problems multipl...
I have a table "Payments" with the following columns
id_payment amount id_type_payment id_project
1 40 1 8
2 ...
This is what I am trying to do
I have data feed coming into Table A and I want to update data from it into Table B
I am trying to use a trigger to do this, for some reason my trigger is ...
Hi,
My current job is like the one below:
BEGIN
dbms_job.change(4,'VER.ADD_DIVISION_PROJECT(TRUNC(sysdate));',SYSDATE,'ADD_MONTHS(to_char(trunc(SYSDATE,''MM''),''DD-MON-YYYY''),1)+2/...
We have a Data Warehouse that is effectively a Data Dump of an Operational System, lets not go into why !! The Data Dump has data loaded into it at the rate or many 10s of Thousands of record...
I have two different Servers
Server A: Linux OS with 9i
Server B: Linux OS with 10g
I want to make a full migration from 9i to 10g; the database is not too large.
i. how do i ftp the d...
plsase resolve my problem " ora 02068 dblink error " in oracle
It shows no logged on
I have file as follows:
"56789","Abc","","Bcde","28"
"456789","Xyz","A","Mno","30"
I want to split first field into 3 different parts as
567 first field
8 second field
9 third field
...
Greetings,
I am currently experiencing problems making a very basic SQL Expression in Crystal Reports XI. Here is the query:
SELECT PATIENT."PATIENT_NUMBER"
FROM "DEV"."PATIENT" PATIE...
Hi,
I need to get a list of all tables and their record count within my Production database and also a list and count of all tables within same schemas in UAT database.
Can anyone give a ...
I'm logged into a solaris8 server via another gateway server, which gives me an ssh connection . So, it's my machine - solaris gateway server - solaris 8 server. There is no tunnel setup, and ...
Hi There
I have two tables table1 and table2 that look like this.
Table1
ID Status
1234 zzzzz
Table2
ID Status StatusDate
1234 xxx ...
Hi guys,
Would you please help me out to understand UPDATE syntax in Oracle 9i.
I need to update selected rows in a table.
In SQL Server it would be something like this:
update Tab...
I have Oracle 9.2.0.8 Standard version so using dataguard is not supported.
I believe I can create a physical Standby database without dataguard at least that is what I see on Metalink. What...
Hai !
I have a table named (report_log) on production box under schema (amen). I have the same schema name on development box.
The task is to export the report_log table from p...
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.
...
