Can you set the currval in a sequence without having to drop and recreate
the sequence?  I rather not have to drop and recreate something because I
have to do a lot more paperwork.  Can't we just use alter or update?
please provide example.

I have a table that is populated with data for the month of June, I need
to add roughly an equal number of rows to the table, but with the dates
in the month of May.
I can do an insert into table_a select

10gR2 EE with Partitioning.
I'm interested to hear peoples opinions on the following scenario.  I
have a 500 million row table which is partitioned by date (weekly).
I'm trying to decide between specifying a maxvalue partition or not.

Dear group,
Currently we have Oracle 10.2.0.3 on RedHat linux AS 3.0, we need to
upgrade our RedHat linux from 3.0 to 4.0.
Will this OS upgrade cause any problem to our DB, software?

We are getting strange deadlocks in 9.2.0.7 database:
1. They occur during INSERT into range-partitioned table where all
indexes are local.
2. Both sessions were trying to execute the same SQL statement.

We are running 10g r2.  Too bad REGEXP_COUNT does not work.  I need to
count the occurances of a string within a string.
It works from when used in a select from a table:
SELECT LENGTH(c1) - LENGTH(REPLACE(c1, 'Oracle', 'Oracl')) FROM x;

My requirements have been changed.  I want to know if a query can be
created that does the following, or am I stuck creating a function in
PL/SQL.
A string will be available in this format:  A:3,B:2,C:5

Does anybody know if there is any difference between ‘*’ and ‘.*’
regular expressions in Oracle? Both seem to work similarly.
Best regards,
lp

I have the following problem. I need to implement a mechanism which
will restore a database to its state in the past. The restore
operation should start on demand. The machanism is supposed to be some
kind of antidote for user errors (e.g. a user had changed data in DB

I used to be a big fan of Oracle support.  When I had some very sticky
situations they came through.  Now they have so segmented it that your
Severity 1 SR is passed around non-stop.  Actually, it is with a lot of
stops.  Each time they pass it around it takes at least 30 minutes ...

We need to change all our ip addresses of all oracle servers.
My specific concern is what we may need to consider for managing
change:-
The following example is my priority

I can run a query in SQPLUS and get results I need.
Select col1
              From tab1 sch, tab2 cmn
              where

I wanna add a user define function as default value of a column.But
oracle raise an error.Could I do that?
Thanks a lot!
Jack.Lee

I'm trying to use an analytic function to get the first row in a group
ordered by a date.
SELECT customer_id, action,
FIRST_VALUE(TRUNC(action_date))

Our database generated an alert with a message that reads:
Disk Utilization for 1 D: is 98.61%
This was generated by the default rules available in 10g. We think it
means there's more activity than normal on the disk, but not too sure