Re: Newbie Tablespace Question

Phil Beckert <pbeckert_at_interaccess.com> wrote in article <pbeckert.1.0014B07F_at_interaccess.com>...
> I've inherited an Oracle (under Netware) database. What are the
 consequences
> of running out of room in a tablespace?

The uncommitted transactions would be rolled back.

 Can the database be damaged as a
> result,

Never heard of this happening

or is it simply a matter of shutting the database down and adding more
> disk space and/or allocating more space on an existing disk?

You can do the above without bringing the database down

If there is
> potential for data loss, how dire are the consequences? Are only
 uncommited
> records affected when the error occurs, or can the database as a whole
 become
> corrupted?

Only uncommitted transactions are lost
>
> I apologize if this is outlined in an FAQ somewhere. If so, point me to
 the
> FAQ, and I'll review it.
>
> Finally, can anyone suggest a good text for a new Oracle database
> administrator?

See oracle WWW site and o'reillys at www.ora.com lots to choose from
>
>
> Thanks,

No problem, Bye, Steve

>
> Phil Beckert
> Lincoln Park Zoo
>
  Received on Wed Nov 20 1996 - 00:00:00 CST