What's best - to resize datafiles or add new ones?

From: Richard Stanton <richardpstanton_at_yahoo.com>
Date: 7 Jan 2003 07:06:07 -0800
Message-ID: <87bc8a5f.0301070706.21d1089c@posting.google.com>

Sorry if this is a stupid question, but I am new to oracle and would appreciate any insight you can offer.

I am running ver 8.0.5 on nt4. It is stored on raid 5.

I have received an error after trying to insert data into a table: "ORA-1653: unable to extend table tablename by 61446 in tablespace tablespace_name". I presume I must either extend the current datafile or add a new one?

I would be grateful if anyone could explain to me which would be the better solution. Does either one require the database or tablespace to be taken offline or backed up?

thanks in advance

Richard Stanton Received on Tue Jan 07 2003 - 09:06:07 CST