Hi,
I am looking for Oracle performance diagnostic sample script based on waits statistics.
Thanks.
Only want to get the export of Constraints. No create tables, no other objects (pcks, procs...)
I have a varchar field that contains special characters. I want to be able to select the field but see the output in hex or dec. For example a line return is chr(13), which is dec 13 or hex ...
Greetings,
We care currently refreshing from our production to our development environment using a cold backup and restoring it to the development database. We wanted to take advantage of s...
What will the SQL be if I want to update fields to table1 which value from table2 ?
Criteria should like following
table1.key1 = othertable.key1
and othertable.key2 =table2.key2
*** M...
hello expert,
I tried to drop a tablespace below and the following
error occured the problem i cannot remember the names
of the materialized views i created how can i go about this
...
Is there a table that stores the name of the alert file in oracle?, I know that it is in the bdump directory but I have other system that runs a progress database an also it is generating a lo...
I have Personal Oracle 9i installed on a machine and an application which runs on the same. This was working fine for past 2 years. Now , when I want to run the application, I am getting the ...
Hi All I am trying to modify a form which has been developed by my seniors . In Layout mode I can see the layout but when I click the run button it runs and closed immediately withing secon...
Here's the SQL script:
update (
select t1.descr as descr_1, t2.descr as descr_2
from tax_juris_mstr t1
inner join sheet1 t2
on t1.juris_id = t2.juris_id
)
set descr_1 = ...
I am trying to open my oracle 9i server through web browser.
example:http://localhost:1521/Solus
Database: Solus,Port: 1521
Is this possible only on 10G?.
its a simple query ,yet taking a very long time :
select *
from nmarket.nm_outbound_sttl_comp_v v
where ptcpt_cd IN ('CCG','CCG_TR', 'CCG_LD')
...
I want to write a function to search the entire database and show a list of table name, field name that contains record which match my query string...I have an compilation error, anyone can he...
I ran SQL*Loader in the evening to insert 2,50,000 Lac rows.
However, SQL*Loader terminated mid may after 4 hrs of loading with error:
Commit point reached - logical record count 225441
...
When I run the following query with SQL * PLUS Worksheet I get an ORA-0431 error, but when I run the same query with SQL Scratchpad it works fine.
Query:
SELECT * FROM APPL_FCS_DB.ORGANISA...
Hi,
I need to write sql statements joining tables across multiple servers. What are the options in Oracle 9i to accomplish this task?
Thanks.
Hi everyone,
I have an issue executing this same procedure multiple times.
Right after compilation it works fine. When I execute the same procedure second time I gets the following error...
Hi Guys,
We run Oracle 9.2 on Solaris 8.
Every week I need to run these 5 select queries and provide the output for statistical purposes (which takes about an hour to complete).:
(1)
...
How to find out the size of oracle blocks???
I haveOracle 9i installed with PHP and Zend Core for Oracle On WinXP to develop a PHP+Oracle based application.
Every day i turn my computer ON and open my Task Manager CPU is being used f...
create table emp (
empno varchar2(10),
deptno varchar2(10),
sal number(10)
)
insert into emp(empno,deptno,sal) values('1','10',101);
insert into emp(empno,deptno,sal) values('2','20',1...
Hi
I am trying to do a date comparison in an SQL select statement on Oracle 9i. The problem in this particular case is that the date is stored in a field only containing the date and the t...
Dear experts!
Hi, again!
I would like to get a list of about 100 most frequently used SQL commands in Oracle 9i, such as
STARTUP MOUNT
SHUTDOWN IMMEDIATE
STARTUP PFILE= 'C:\ ...
Hi all,
Could anyone please clarify me the below questions,
1. I am doing an database upgrade from Oracle 9i to 10gR2 and this is on Solaris 9.5 64 SPARC. My question here is, ca...
folks i have a trigger
i want to run a insert from one select istatement nto two tables
i .e select id,description,type from table a
and insert id,type into table b
insert id...
