Re: Expand the tablespace in Personal Oracle?

Tim Nguyen wrote:
>
> Anyone know how to expand the tablespace in Personal Oracle
> for Windows 95? The user's tablespace is only around 3Mb.
> --
> ==============================================================================
> .--_-_-_--. _____________________________ { \_____/ } _________
> | (_|_|_) | #include <disclaimer.h> { }
> . | (_|_) | #include <whittycomment.h> '~. `[ ]` .~' Australia,

You could add another datafile to the tablespace or, if you're running 7.2 or later, you can manually resize the tablespace's underlying datafile or declare it to be 'autoextend'.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.