I am using RMAN to do hot backup.  Let's say, I did a point-in-time
RMAN restore using yesterday's backup and database is now opened by
doing "resetlog".  Since the log is reset, I need to do "reset
database" to the RMAN catalog.

Is it the size of a tablespace that limits the rollback segment?  I am
trying to delete a large amount of data in a table and get an error that the
rollback segment could not be created.

Hello Oracle experts,
I want to store date and time values always in UTC (paying attention to
daylight savings) in a DATE filed as a default value.
(eg.: MYDATE DATE DEFAULT=???sysdate???)

I am trying to upgrade Oracle 8.1.7 to Oracle 9.2 using database upgrade
assistant and while doing that I am getting error at final Step 4 after
clicking the Finish button error msg is
"90MB of Free disk space not available at D:\ORACLE9\oradata\Datenbank to

whats the best practice to count the number of commits
-done to an instance
-done to a table
thanks in advance.

Hi all, does anybody knows why, all of a sudden,  queries to slow an
freeze with
APPEND BYPASS_RECURSIVE_CHECK hint and recursive insert into tem
dynamic system tables?

Why to I need to add the number 2 to the following SQL to get the real
numerical equivalent of a date?
select 2 + (to_date('01-12-2005', 'DD-MM-YYYY') -
to_date('01-01-1900','DD-MM-YYYY')) from dual

Hello, I can do this at the sqlplus prompt:
select sys_context( 'USERENV', 'CLIENT_IDENTIFIER') from dual;
Yet when I have the following in a function:
f_clientid  := sys_context( 'USERENV', 'CLIENT_IDENTIFIER');

Need help on my assignment.... I have finished all ecept the sqlquestion. I
have created an ms access tables but need it in Oracle SQL.  Please help
The question is as below
6. Define normalised relations as SQL tables enforcing all apllicable

We have some analysts based in another part of the business,
They are wanting to connect to our oracle database.
The firewall has been opened up by the I&O team.
The analysts can ping the oracle server successfully, but they can not

On my first server installed oracle 8.1.7  and I want to transfer
database from it to database
my second server (oracle 10g Release2).
How can I do this?

My company LOVES metrics.  And it is time again to write our 'goals'.
They must be measurable.  Why am I asking for help in writing goals
here? Because all the finance people wrote theirs in terms to have to
be a financial wizard to understand for starters.  Now all the other

Can you specify a column as the partitioning column if that column is
populated by a trigger?
Assuming that i have a non-partitioned table and i intend to partition
it and example is a date_created which is timestamp and this is

                I just wanna know is there any way to load LOB data
from a file into Oracle table using SqlLoader? I have gone through the
docs which says something about the LOBFILE parameter. but i am not
able to frame my control file properly.

Currently we have an app that maintains an audit trail manually via
triggers, almost identical to the way Flashback Versions Query provides
results with the pseudocolumns versions_operation, versions_starttime,
versions_endtime, etc.