Re: Newbie Tablespace Question

Phil Beckert wrote:
>
> I've inherited an Oracle (under Netware) database. What are the consequences
> of running out of room in a tablespace? Can the database be damaged as a
> result, 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? 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?

  You can add a datafile to the tablespace by using the command: ALTER TABLESPACE tbs_name ADD DATAFILE ...   

  Alternatively, you can modify the storage parameter to increase the maxextent.

  Anyway, there is no any impact on the data if it runs out of space. The current SQL statement will be rollback.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841