Re: Expanding Database Size

Expanding the database is adding a new tablespace or creating a new datafile for a tablespace .

The command you should use should be

  ALTER TABLESPACE yourtablespacename ADD DATAFILE ('file specs including path') SIZE n;

Where n is the size of the file to add eg. 50M , or 200K

However it seems that your problem is too general , are you encountering any error messages ? What is the Error number and the message ? It could be a miss sized table and not a miss sized tablespace .

Read more about this before you try anything .....

Joe Schwartz wrote:
>
> Hi everyone,
> Please excuse my ignorance in advance. I'm an absolute
> beginner at Oracle DBA functions.
> I created a database on an NT server (3.51) running Oracle
> 7.3. I made the database too small, so that users running a software
> package using the Oracle engine are unable to add records. Can someone
> please help me out with expanding the database (without, of course,
> losing the existing data). I could either create additional extents,
> create and format a new database and move data to it, etc., whatever
> you think is best. Since I don't know how to do any of the above, any
> help would be appreciated. I've read the manuals with no luck, and am
> scheduled for training, but this problem is immediate. Please E-Mail
> me at jschwrtz_at_aes.tracor.com. Thank you.
>
> Joe

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================