I am playing around with trigger (luckily in a test machine) and now cannot
login anymore (even sys).  Could anyone help me to resolve the problem.
Using 'user1' account, I defined a DDL trigger for logon to log all user's
logon:

I executed a script from sqlplus which included a && prameter.I executed
completely.Now I want to execute it for second time but it does not free that
&& variable and do not ask for it from me.
I cleared buffer but no chance.What should I do to undefine this in the same

We're running ASMLib kernel driver on a Linux 2.4 kernel, with
PowerPath against an EMC SAN. Metalink note "Configuring Oracle ASMLib
of Multipath Disks (309815.1)" applies. Oracle 10.1.0.3.
We have been getting I/O errors and corrupted data block reported by

I am learning Oracle 10G on windows 2000 and Linux. I setup flashback
recovery area and have written RMAN scripts to do disk backup. I want
to test backup recovery area command. I don't have any tape
devices/media management libraries. Is there any way to copy contents

Apologies for the cross-post. Followups set to
comp.databases.oracle.misc
My environment:
Windows XP SP1. I have adminstrator access.

Hi experts,
indulge me in this scenario:
as part of our backup strategy we take a copy of our dbf files (data,
undo, indx01 etc etc), together with the various *.ora files (init,

We have 2 servers with the following configuration:
role    server               SID
------- -------------------  ---
primary sapsnd.ic.ssmhc.com  SND

We need to process some data (using PL/SQL) from Oracle tables and at
the end we need to put the result (2 temporary Oracle tables) into 2
DBF files (composed of the same fields which exist at Oracle tables).
We would not like to have any additional step other than run the Oracle

I have 150 tables and i want to have them replicated on three sites.
two of the sites are running oracle standard edition and one
enterprise. What's the best way to do that?.
Can anyone tell me what's the advantages/disadvantages of oracle

Hi, what is the equivalent oracle DML for the below mentioned sybase one,
update    Table1
set      a.column3 = b.value3,
    a.column4 = b.value4,

I found a problem with running Oracle10g on Solaris10 Sparc machine.
I've installed it successfully (as metalink recommends...;-) with
patchset  10.1.0.4 so officcially Oracle with this patchset supports
solaris10 sparc. When i try to start instance i'm receiving a error

Is there a practical limit on the size of database tables in Oracle?
Ideally I'd like some examples of systems that have tables containing many
millions (or even billions of records), an indication of the size of server
being used to run the database, the type of queries being ...

I have an update statement that updates 40 rows based on the
results of a select query. The select query when run by itself returns
about 250 rows.
I am trying to set the value of another column in a table based on the

I've been looking through the 10g manuals to try to understand exactly what
Cluster Ready Services (CRS) is for and have failed.  I have found some
command-line references for how to put processes, instances and applications
under CRS control.

On metalink i found a note "Data Guard 9i - New archival Destinations for 9i
Database"
containing the following paragraph:
<knip>