| Ask Tom HOT ARTICLES |
| Ajouter ce flux dans votre site |
| Description: |
These are the questions on Ask Tom that have the most comments |
| Format: |
RSS 0.91 |
| Url: |
http://asktom.oracle.com/pls/ask/ask_tom.hot.rss?p_count=20 |
| |
| Derniers Titres |
Ask Tom HOT ARTICLES
|
Question on CONCAT
2008-11-11
Hi Tom,
Good Morning...
In my Procedure.
<code>CONCAT(<SQL_QUERY>,<CASE_STATEMENT>)</code> is not working
but
<code><SQL_QUER>||<CASE_STATEMENT></code> is working
Why??
|
ORA-00001: unique constraint (GIGAGAME.PLAYERINFO_IDX2) violated
2008-10-29
Hi Tom
I have problem need to help
My Company RD TESTING FIND THE PROBLEM
ORA-00001: unique constraint (GIGAGAME.PLAYERINFO_IDX2) violated
HOW CAN I RESOLVE PROBLEM
Tks
schema ???
DROP TABLE PlayerInfo;
CREATE TABLE PlayerInfo
(
CID...
|
How to tune access of "fat" tables
2008-10-29
Hello Tom,
I'm working at a client's site who has a data warehouse with partitioned fact tables with about 400 columns. Performance is not too good and I am trying to optimize the system a bit.
The client told me that most of the columns are quer...
|
Restoring Stats and Execution Plans
2008-10-28
Hey Tom,
We recently had a query (using bind variables) whose plan flipped after our nightly stats gathering process due to bind variable peeking. We were hoping that by restoring stats to the previous day (on all the tables included in the query...
|
oracle is doing full table scans on a table with raw column and the column is primary key
2008-10-28
Hi Tom,
Thanks for your continuous support.
We have a table with blob data type as one column. We are using secure file option as we are using 11g. We kept the blob column in a seperate tablespace. In the main table we have a column called...
|
Spfile Question
2008-10-28
I m a beginner in field of oracle .
Consider a spfile , now if i make changes to the parameters in this during the running instance (using alter system set parameter....), will this change be applied in current running instance or will it be applie...
|
Trying to select rows which got certain attributes
2008-10-28
Hi
I have the following situation. My table got the following data
SR_WID activity_type activity_subtype
1 Maintenance Break fix
1 Install startup
2 Install startup
3 Install startup
3...
|
SQL*Plus IN/LIKE Capability
2008-10-27
<code>
Tom,
In sql*plus we can do an IN...
select * from x
where animals IN ('DOG', 'CAT', 'RAT')
/
Or we can do a LIKE...
select * from x
where animals LIKE ('%OG')
But if we want BOTH we have to do this...
select * from x
wh...
|
Database Backup Strategy
2008-10-26
Tom,
Because of a situation with one of our production databases we are in the midst of rethinking our entire database backup strategy.
It seems that regular, routine test recovery of a backup from tape for all production databases is the only ...
|
A tough status problem needs help
2008-10-26
Tom, I believe I did NOT make this thru last time(my computer crashed last time right after submit this question), and I still did NOT receive your response, so I give it another try, please ignore this if you already received this very same question...
|
