How will be the career oppurtunities for  DBAs on multiple
databases..i am a coredba on MSSQL for past 5years and i have a great
desire to work on Oracle as a dba..i have enough skills for that.. But
the issue is i have just 1 year experience as a DBA in multiple

To all,
How do you stop the debugger when you encounter an error ?
I have tried using STEP OUT (CTRL T)  and BREAK (SHIFT+ESC) and neither
works.

I recently did a 10g installation on my PC and encountered some problems
During installation I got the following error message :
"Thrown when the IP address of a host cannot be determined"
this is because my PC has a dynamic IP address

Is there any method of resetting storage parameters on a bunch of tables?
Perhaps something with exp/imp that would recreate the tables with the
default storage parameters?  Some procedure that would retain data,
constraints and grants.

In my application working on oracle 10g database and Red Hat Linux
Advanced Server 2.1 on HP Itanium pcs.
When i use in my query statements like
update table1 set colmn_dt = to_date(sysdate,'DD/MON/YYYY');

Oracle version 8.1.7.4
OS - Solaris 5.8
Archiving enabled
I recently restored a database from server A to server B. Server B has

If I create a new table in 8.1.7.4 and don't specify any storage parameters
when doing so, how are the initial_extent and next_extent determined?

Dear Gurus,
Oracle's documentation mentions that it can automatically mirror online
Transaction Logs.
I'd like to know if Oracle can be configured to mirror the Rollback

Suppose I have a table A that has a field PARENT_SEQ_I that is a FK
onto the same table field SEQ_I.
Also, suppose that the parent record in the 'group' has PARENT_SEQ_I
set to point to its own SEQ_I.

Oracle version embedded.
Situation :- logged in to the UNIX account which owns Oracle, and opening
Sqlplus with the sys account.
Problem:-  The sys account doesn't seem to care what password is used,

I would like to use random numbers in my pl/sql code..
do I really need to user dbms_random package or there is another to do
so ?
if so, how could I use dbms_random to generate positive random

I create a trigger to perform a mupsert.
Oracle 9.2.0.6 on Solaris 64-bit.
The old time way works.
CREATE OR REPLACE TRIGGER TRG_GPS_MOBILITY

Platform: oracle 9iR2 / Solaris 9
This probably a very simple answer. We have a table with text indexed
documents.
The following query will retrieve circa 16,000 rows.

We have a tablespace that is now much bigger than needed to
hold the data in it, and I would like to shrink it.
However, all datafiles have some extents allocated near the end of the
file,

I have two redo log members for each group (each member on a separate
disk say disk 1 and disk 2). The archive_dest is on disk 3.
How does the archiver decide from which member to archive from (disk 1
or disk2)?