| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Oracle Data Access Interview Questions 333
http://seeallinterviewquestions.blogspot.com/2008/07/oracle-data-access-interview-questions.html
oracle...
swathi
|
08-03-2008 01:57 AM
swathi  | 0 | 16 |
 | | Hi,
Few days ago my database "eat" a lots of CPU and has high events waits
and I/O waits. Now problem is gone, but I want to know what to do...
kawu
|
08-02-2008 03:16 PM
Mladen Gogala | 35 | 46 |
| | | Hi,
I have 2 tables:
CUSTOMER_ID C1 C2
123 ABC x
456 DEF x
789 GHI P
SQL> select * from y;
artmerar@yahoo.com
|
08-01-2008 12:59 PM
cc | 7 | 13 |
| | | Hi,
I am using Oracle 10.2.0.2.0 on a Windows Server 2000 box.
I am attempting to perform a full export of the database using exp.
When it gets to...
Paul
|
08-01-2008 09:58 AM
Paul | 28 | 34 |
| | | Hi,
What the practical difference/utility beween CHARACTERSET and
NATIONAL CHARACTERSET ?
In other words why NATIONAL CHARACTERSET was introduced...
astalavista
|
08-01-2008 08:54 AM
Ana C. Dent | 63 | 78 |
| | | Hi.
Here is an utility I wrote and use, maybe someone else will find it
useful too.
Oracle SPY
-- Dennis Yurichev <dennis (AT) conus (DOT) info>...
Dennis Yurichev
|
08-01-2008 03:03 AM
ErikYkema | 14 | 25 |
| | | 10.2.0.3 EE on Red Hat EL 4
How can you update the log_arc_dest parameters on a database which is
managed by the Data Guard Broker...
I've tried...
mccmx@hotmail.com
|
07-31-2008 05:51 PM
mccmx@hotmail.com | 28 | 32 |
| | | Dereck L. Dietz wrote:
Look at the demo in Morgan's Library under Array Processing.
There is no need to define or pass anything. Oracle, on its...
DA Morgan
|
07-31-2008 05:40 PM
DA Morgan | 6 | 15 |
| | | On 31 Jul, 14:13, μΙΤΟΧήΕΞΛΟ εΧΗΕΞΙΚ <litovche... (AT) ogk6 (DOT) ru> wrote:
A query such as the following might help shed some light on...
gazzag
|
07-31-2008 03:42 PM
Gints Plivna | 27 | 39 |
| | | Hi,
We just implemented RMAN and were reading the documentation and came
across this:
"For example, you can implement a three-level backup scheme...
artmerar@yahoo.com
|
07-31-2008 03:07 PM
Palooka | 35 | 39 |
| | | Dear gurus,
I had this message when i tried to export a schema, please tell me why
this happens?
i ran this script, exp schema/schema@sid...
pejantan4u
|
07-31-2008 12:42 PM
joel garry | 7 | 28 |
| | | ONLINE RESOURCE FOR HELP DESK SOFTWARE
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
http://helpdesksoftwaremanagement.blogspot.com
jasmine956@gmail.com
|
07-31-2008 01:48 AM
jasmine956@gmail.com | 0 | 14 |
| | | Hello all,
Is it safe to move/compress (gzip) *.trc files from oracle dump
directories while database instance is up?
I'm getting some of these...
Frank R.
|
07-30-2008 09:50 AM
fitzjarrell@cox.net | 63 | 79 |
| | | I was experimenting a bit with symfony (http://www.symfony-project.org)
a freeware application generator more potent then APEX. It is easy to
add...
Mladen Gogala
|
07-30-2008 09:10 AM
Puentes Diaz, Roberto G. (puentesdiaz@gmail.com) | 37 | 61 |
| | | Hi
Today I have problem. In tablespace I don't have free space. I add
datafile to that tablespce. Should I do or check something else to be
sure...
kawu
|
07-30-2008 08:59 AM
kawu | 14 | 28 |
| | | Hi
when I start my listener I get the following appear on the screen
Listening Endpoints...
obakesan
|
07-30-2008 07:51 AM
obakesan | 14 | 27 |
| | | Hi,
We just migrated to Oracle 10g, from 8i. We had one question about
UNDO. The documentation states that the UNDO table space keeps the
'undo'...
artmerar@yahoo.com
|
07-30-2008 07:38 AM
Mark D Powell | 28 | 40 |
| | | Hello, I know this code will convert on the fly an XML document to a table:
SELECT
xml.extract('//EMPNO/text()') as...
yossarian
|
07-29-2008 06:51 AM
yossarian | 0 | 22 |
| | | Dear Group members,
I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and
8i
it is working very good with the 9i and 10g..
when i...
ranganadh
|
07-28-2008 03:59 PM
Jesper Wolf Jespersen | 7 | 25 |
| | | Hi,
We are migrating from Oracle 6i to Crystal Reports. Oracle reports
were built using Oracle 6i Data Wizard and Query Builder. How can we
see the...
bang123
|
07-28-2008 12:13 PM
Malcolm Dew-Jones | 20 | 43 |
| | | I want to see if I can create a slick query to do this and cut down on
some code.
I have a list of dates & statuses like this:
01/05/08...
artmerar@yahoo.com
|
07-28-2008 07:59 AM
cc | 35 | 53 |
| | | Hello Everyone,
I have a clob column in a table, which has a jsp in that....
<table
align="center">
<tr>
<td colspan="30">
<script>
if...
venki
|
07-28-2008 04:29 AM
venki | 0 | 15 |
| | | Hi All,
Is it possible to install oracle 9i and oracle 10g in one solaris 10
server?
Thanks
Ed
Ed
|
07-27-2008 06:42 PM
Palooka | 42 | 61 |
| | | Hi.
I'm looking for any publically available SQL code set, which cover as
many Oracle RDBMS (10g or 11g) features as possible: SQL, PL/SQL,...
Dennis Yurichev
|
07-26-2008 05:46 PM
hpuxrac | 21 | 41 |
| | | Hi,
I figured I'd ask this too. I know how to remove duplicate rows from
a table, but this example used an analytical function. I'm new to
these...
artmerar@yahoo.com
|
07-26-2008 08:46 AM
Serge Rielau | 14 | 28 |
| | | HELOOO fRIENDS.....
Watch and enjoy SECRET WEB CAMS at LADIES HOSTELS And
5 STARS HOTELS, M M S Clips, INTERNET CAFE center...
Enjoy
|
07-26-2008 04:54 AM
Enjoy | 0 | 15 |
| | | On Jul 23, 5:20*pm, "Dereck L. Dietz" <diet... (AT) ameritech (DOT) net> wrote:
The dbconsole is a GUI app added with the 10G install that runs in...
sybrandb@hccnet.nl
|
07-25-2008 04:26 PM
joel garry | 21 | 50 |
| | | Dear Partners,
Interested parties can forward their consultants profile to
versatilehr.farook (AT) gmail (DOT) com with their contact information...
Farook Ahmed
|
07-25-2008 03:42 PM
DA Morgan | 28 | 39 |
| | | FREE SOFTWARE FOUNDATION
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
http://freesoftware20.blogspot.com
hpeeeter2@gmail.com
|
07-25-2008 08:46 AM
hpeeeter2@gmail.com | 0 | 13 |
| | | FREE SOFTWARE FOUNDATION
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
http://freesoftware20.blogspot.com
hpeeeter2@gmail.com
|
07-25-2008 08:46 AM
hpeeeter2@gmail.com | 0 | 16 |
| | | Giuen Interpose & Outright Company
A New Generation Outright Company begun in 2008 the funding for a
battlefield data link that projected data onto...
rogerkolsson@yahoo.co.uk
|
07-25-2008 05:39 AM
rogerkolsson@yahoo.co.uk | 0 | 16 |
| | | Hi
i have 11g installed on redhat 5.1, and i can't seem to get the
enterprise manager db control page. If i try http://myserver:1158/em/
i get a...
rgvguplb
|
07-24-2008 08:40 PM
rgvguplb | 49 | 73 |
| | | I am just starting out as Oracle DBA, been on other RDBMS. I finished
exp/imp a schema from from another oracle instance. Everything looked
good...
Richard
|
07-24-2008 07:12 PM
Richard | 0 | 15 |
| | | On Jul 24, 2:36*pm, "Dereck L. Dietz" <diet... (AT) ameritech (DOT) net> wrote:
I think most of the comments made in your prior post speak...
hpuxrac
|
07-24-2008 05:19 PM
hpuxrac | 2 | 17 |
| | | We have an application that was written using SQL Server 2000 as the
RDBMS. We now have a need to convert this to Oracle. We know that we
obviously...
tcole6
|
07-24-2008 01:10 PM
DA Morgan | 175 | 224 |
| | | Hi,
We are running Oracle 10.2.0.1.0. We want to upgrade to the latest
patchset, 10.2.0.4.
I guess first, is this really necessary. Also, we I...
Mtek
|
07-24-2008 01:08 PM
joel garry | 28 | 60 |
| | | Hi,
I've created a trigger using the script below.
whenever I fire it by the statement
update site_control_t set oid = oid;
I get
ERROR at line...
freecycle
|
07-24-2008 04:42 AM
Vladimir M. Zakharychev | 49 | 61 |
| | | Guys,
I need help with a Oracle E-Business install on a test system (Windows
Vista) on my PC at home..
This is basically a test system for learning...
newbie
|
07-24-2008 04:04 AM
Shakespeare | 21 | 41 |
| | | INTERNATIONAL HOTELS
http://internationalhotelsdetail.blogspot.com
RAJINI
|
07-24-2008 03:02 AM
RAJINI | 0 | 17 |
| | | Hi ,
I would be more then happy to take you across www.qaguild.com , where
QA and testing professionals meet online and discuss on QA and...
reetha.ps@gmail.com
|
07-24-2008 12:38 AM
reetha.ps@gmail.com | 0 | 13 |
| | | Hi group,
I'm just wondering - and I tried to look it up in the documentation:
When I submit a dbms_job calling a pl/sql-procedure and this...
steph
|
07-23-2008 05:38 PM
Palooka | 49 | 58 |
| | | Hello all
I am the happy heir of a server running Red Hat Enterprise 3 with Oracle
10.2g. This server is used for integration purposes. Every night,...
Giganews
|
07-23-2008 01:18 PM
joel garry | 35 | 63 |
| | | Oracle DBA/Apps DBA
Location(State/city): NY/NJ
Duration: 6 Months
Req Details:
This position is to provide Oracle Database support for...
prakashepro@gmail.com
|
07-23-2008 01:00 PM
Mark D Powell | 7 | 18 |
| | | Does anyone know if it is possible to instal Oracle 8i personal to a
PC tha only has 10g, or will I have to have to install oracle 8i as
well.
kshuter@gmail.com
|
07-23-2008 12:19 PM
Terry Dykstra | 21 | 36 |
| | | Dear Partners,
Interested parties can forward their consultants profile to
versatilehr.farook (AT) gmail (DOT) com with their contact information...
Farook Ahmed
|
07-23-2008 11:55 AM
Farook Ahmed | 0 | 15 |
| | | I am new to Oracle.
For a project at my work we need to model our system. The system will
be developped with an Oracle (9i, 10) database.
Now I...
B.Coenen@gmail.com
|
07-23-2008 11:50 AM
Precipice Development Intl | 21 | 33 |
| | | Hi ,Now you can post your Coding problems on techfaq360. post
problems : http://www.techforum360.com
Java Day to Day code Examples on :...
TechFaq360
|
07-23-2008 06:16 AM
TechFaq360 | 0 | 13 |
| | | Is it possibile (and how) to get field's default values using MetaData
class?
Thnx
Damu
|
07-23-2008 05:59 AM
Damu | 0 | 16 |
| | | This is a question on 10g analytic functions
I have Table T1 with four number columns:
Table T1:
id X Y Z
1 0 0 0
1 0 1 0
2 0 1 1
2 1 1 1
GuangMei
|
07-22-2008 09:18 PM
Vince | 7 | 20 |
| | | Hello,
Have a 10G server on solaris 10 sparc with 16GB.
An alarmed user has pointed out that the memory usage look very high.
I dunno whether the...
martin_ian_lewis@yahoo.com
|
07-22-2008 05:35 PM
DA Morgan | 63 | 94 |
