I have a bunch of columns that are a CHAR(1) and should only contain
"Y" (for Yes) and "N" (for No).
Instead of creating a separate check constraint for each and every
column, is there a way to set up one check constraint and reuse it for

I created a tablespace with the following parameters.
extent management local autoallocate
segment space management auto
Under this setting Oracle will extend in increments of 64k, 1m, 8m, and

We switched to RMAN managed backups. Prior to this we deleted
archivelogs by means of OS. Now I made database backup, and then
archivelog backup. I tested if I can restore archivelog from backup and
I have got thes message:

i need to drop a database asap as i cannot mount the oracle instance.
my trouble started when i tried to rename the database using the
DBNEWID utility.
nid target=sys/pwd@mydb dbname=mydb2

I am using Oracle 8.1.7 standard edition. I have a database instance, and I
can login to it with "sqlplus username/password@dbname", but when I login
with "sqlplus username/password", login fail and error message is:

May I know how can I check what store proc are  currently running on
the oracle ?
Best Regs

i was using oracle 10g datapump for exporting my schema. i was able to export
and to import the same schema and i have done it sucessufully many times...
now when i try the same thing it shows  following error
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.

My windows has formatted and now I have only my oracle useless files.My last
backup is about 1 week old so I want to restore datafiles without using that
backup and just by datafiles and controlfiles and ...
Do you know how is it possible? Can I install new oracle and create a

In TOAD, when I execute the following INSERT statements
with semi-colon in the end, I will get error
"ORA-00911: invalid character"
INSERT INTO T1 (A, B) VALUES ('Joe','1001');

How can I get information about server IP adress and port number using
SQL? I know sys_context function but using it - I can get info only
about session. The view v$instance give me name of server host - but I
need IP adress and port...

In response to a post on comp.databases I did a bit of testing and
found a very strange result.
This works in Firebird (and something similar apparently works in
MySQL)

  I am trying to generate a flat file with the following layout from
an Oracle table:
  Column       Start     End      Length
 --------     -------   -----    --------

I'm looking for a list about feature-differences, hardware-requirements and
prices.
Where can I find this type of overview?
Greetings

I am a fresh dba. I have a problem that if the database crash, what
procedures should I do?
1. try to "startup" the database again.
2. if "startup" failed, check what problems in the alert log file.

Most of the documentation you see about setting swap space for an
Oracle box states that swap should be equal to RAM.  With the size of
RAM now days getting to 64Gig or more, is this really a requirement?
Is there a good standard to follow?