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...
Hi,
I am using Oracle 9i and Unix on my system and trying to execute a UNIX shell command through external procedure in C.
I created a shared lib (libextproc.so) for the following functi...
A couple of weeks ago we installed the Oracle client software on our development IIS box so that we can connect a legacy ASP application to a remote development oracle database server. An ODB...
Hi,
I created a report with delimiteddata (ORACLE forms and reports and iAS 9i), the report is showed on the preview screen very well, however I found that if I add to the report URL the fo...
Hi,
I am quite new the oracle reports. I have a forms from which an oracle reports are to be called.
I have done a simple oracle reports, its just a single query and called it from oracle ...
I need to increate the size for PSAPUNDO tablespace on Oracle on Windows.
I've never done it before and it's quite urgent.
How can I do it? Do I need to use BRTOOLS?
Thanks,
Felipe
I am attempting to do a full export of one of my database and recieving ORA-00904...here is my syntax and some other info I have found...I beleive the issue is the veiw version but not 100%
...
The following is one of the query of the report running in oracle applications 11.5.10 using database 10.
When i checked the explain plan in TOAD of this query in 10 the cost is more around ...
oracle 9.2.0.7.0
HP-UX machine
i want to take a schema export from production server and import into a different unix server.
1)how to use pipes to export and import this dump?as the d...
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...
I have a unix script that has some oracle statemets in it. I am truncating an oracle table and I would like to check for an error if the truncate file. How do I check if the trucate file in th...
Oracle 9i,
When I view the rc_backup_piece table via SQLPLUS, my backupsets goes as far back as Jan 2002. My retention policy is set to 366 days. When I issue the delete obsolete command in R...
Hi All,
I have a question regarding how to delete rows.Here is the question:
1.I have a table with around 11,000 rows.
2.Table sql statement is :
CREATE TABLE M_10
( ID1 NUMBER(6,0...
Good Morning
Does anyone know when "End-Of-Support for Oracle 9i Release2" will occur?
If it hasn't happened already.
Regards
Hello
Im used to sql servers and connections between tables and so on now i want to try how Oracle databases work.
But im having problem how to connect and insert data to oracle database...
I've inherited an Oracle 9i system.
I have plenty of Database experience, just not in Oracle.
I have a feeling that the SYS and the SYSTEM users are not set up correctly.
Where can I fin...
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 ...
how to write Oracle Sql query to find only the records which are exclusively locked by particular session user.
Hi,
just few days back we have done a installation of Oracle 9i on Solaris server. we also have our Weblogic and application running on the same server. Server has 2 CPU with 2 GB of RAM.
...
During certain processes on my DB the disk I/O hits 100%, then the CPU is held in a WAIT state. No other processes can be run at the same time. I was using SORT_AREA_SIZE & SORT_RETAINED_SIZE ...
Hi There
I have two tables table1 and table2 that look like this.
Table1
ID Status
1234 zzzzz
Table2
ID Status StatusDate
1234 xxx ...
Guys
I have a question this is only theoretical not actually happening.
If I have a database in archive log mode which I take a COLD backup of can I restore this database to be upto date...
"ORA-29275 partial multibyte character. Cause: The requested read operation could not complete because a partial multibyte character was found at the end of the input.
Action: Ensure that the...
I have oracle 9.2.0.7 running on Windows 2003 Server with 4Gb RAM.
Random I recive the error
ORA-12547: TNS:lost contact
This appears when the backup run (yesterday all run fine todaz afte...
I have 2 tables accounts(a_id) and names(a_id,n_id,flag1,flag2)
I need a select query as following
select a.a_id,n.n_id,flag1,flag2
from accounts a,names n
where a.a_id = n.a_id(+)
...
