I'm using Oracle 10g XE. Is there a way to change the default service
name from 'XE' to something else?
Thanks in advance,
Filipe Correia

I have full export of a database [Oracle 7] taken with rows=N option.
Now I want to create the same database (structure only, as it doesnt
contain the data) on some other machine [Oracle 10gR2]. For that I
created a new database, then created tablespaces, of 150 MB each with

All,
Let me know your thoughts on the below.  My client blew away his OCR.
I did a restore of the OCR and now the db won't start.  Here's the
command line syntax and tail of the crs log:

I'm working on tuning a particular query and have gotten the explain
plan as pretty as possible, low cost, etc.  However, when running the
query (an insert into table select ... statement), I find the
following information in the tkprof trace file:

I was told by someone that the general rule of thumb for the initial memory
allocation in an Oracle instance was something like 40% for the SGA and 60%
for the PGA.
Anybody willing to comment on how accurate/inaccurate that statement was?

Win a free guitar today!!!!
http://freeguitars.blogspot.com/

In the database I work on at work it appears that there are many user
accounts which have been created with the system privilege UNLIMITED
TABLESPACE.
I brought this to the attention of my manager mentioning that no user

We have set up a OID one-way LDAP replication. Last night, the replica
filesystem got corrupted. Since we do not have a good backup of this
replica, I tried to reinstall the replica. During the install process,
the installer complained that the database was already registered with

The Workflow Notification Mailer can be configured to work with any
SMTP/IMAP server?

All of our tables have PUBLIC synonyms and of course PUBLIC has SELECT
privileges on all of them. How can I make some of them visible ONLY to
certain users?  If I drop the PUBLIC synonyms, nobody except the owner
can see them. If I keep the PUBLIC synonyms everyone sees them.  We

I'm new to oracle, I installed oracle 10g  version 2 and I'm the
administrator on this box.  I'm trying to execute the
dbms_errlog.create_error_log command  through SQL Plus but I keep
getting the error message:

I've had a problem with (probably) simple query. I want to update one
field in one table when another field in this table is equal to
another field in another table (they have the same type of course).
This should be something like this (each table has two field - id and

I have the latest ActivePerl installed on my laptop, and Oracle 10g
personal edition as well. When I run a perl script that uses any
modules, I get a message like this:
Perl lib version (v5.8.3) doesn't match executable version (v5.8.8) at

I'm still relatively green as a DBA, so excuse the possibly simple
question...
We have a DB that is seeing a lot of deadlocks, occasionally hundreds
at a time.  Yes, typically this is an external-application/development