Hi Gurus,
I have 2 sites, a master site on A and an MV site on B using primary
keys on the replicated tables. The set up, briefly, and in no
particular order, is:

 I have edited Oracle's standard verify_function created by
utlpwdmg.sql to include the following special characters: ~ .  ^ { }
[ ] | \
 Password containing ~ or { or } work just fine.  For the others, I

Hi Partners,
I am really greatful to you all for being so helpful in getting
assignments for my Consultant.
I really appreciate your time for responding to me.

I'm new to Oracle DB's and have a basic question about update access
to data through views. Is it possible for a user with the update
privilege to a view, like sys.dba_audit_trail to make changes to the
data they can access through the view and if so, do they require

I've seen many discussion on setting NLS_DATE_FORMAT. But when I tried
to set NLS_DATE_FORMAT inside jdbc, it didn't seem to have any effect.
Please see my codes below. Anyone has an idea?
Many thanks

I've got an PL/SQL Error:
SQL> declare
  2  v_tmp char(15);
  3  BEGIN

I am supporting a ERP application, do not have access to source code.
crsor_sharing is set to force so when I look in v$sql etc it shows me
the statement with various bind varaiables. Is there any way to find
the original query before Oracle replaced literals by bind variables.

Siebel Analytics Developer
Irvine, CA
6+ months
Direct Client needs a candidate. Reply with rate/availability ASAP.

This is 10.2.0.3 database on Linux. My application developers have
installed an application that utilizes advanced queueing and the CPU
consumption skyrocketed. The 3 SQL statements consuming most CPU are all
related to AQ. The "Streams AQ: waiting for messages in the queue" ...

I've never dealt with Nested Tables.  I've read a bit on them, and it
says you cannot move them.  The nested table is supposed to reside in
the same tablespace as its master table, but this is not so.
I moved the master table to a new tablespace, and the nested table

Hi Partners,
I am really greatful to you all for being so helpful in getting
assignments for my 2 Consultants.
I really appreciate your time for responding to me.

anyone know how I can rename a table in SQL (if its possible)
eg something like
RENAME mytbl as newtable

how can i do this in pl-sql?
when lines=2 that is replaced by a 1 allowing that math to take place
when lines>2 it adds the other piece instead. Trying to avoid if
statements.

is it possible to retrieve from a Stored Procedure the remote
host name or address who owns the Session ?
Thanks
Laura

Trying to lower the cost of the query below, do to the large disk read
for the table services.
SELECT SERVER_ID,SERVER_NAME
 FROM serverdb.servers