Re: Newbie: Creating new database files

Ade wrote:
> No I don't have separate disks on my home PC. The main reason here is to
> keep the database files for each application away from other apps.
>
> I have learnt quite a bit about tablespaces over the last week or so,
> especially the fact that Oracle 10g Express won't, in itself, let you create
> any within the GUI. However, using the SQLPLUS that comes along with it is a
> different matter. In that you can manipulate the entities (for want of a
> better word) a whole lot better.
>
> I still can't find the command to extend a file once created though. I
> initially entered the following;
>
> SQL> create tablespace datafile 'c:\trash\my_tablespace.dbf' size 200000;
>
> I then had a look in the directory and saw the 200,000 byte file (I was kind
> of expecting it in 512 byte blocks - oh well that's VMS for ya!) so I
> decided to try to extend it but couldn't find the command.
>
> Looking on the web, I have found that you should initialize to what you
> think should last for a while and include the extend clause in the create
> statement. Still wouldn't mind a single command to extend it though.
>
> Thanks to all,
>
> Ade

Here is an example that includes most of the options when creating a tablespace in 10g:
CREATE SMALLFILE TABLESPACE "MY_APP1" LOGGING DATAFILE 'c:\trash\my_tablespace.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Obviously, set the SIZE and NEXT parameters as required. The example uses ASSM. I suggest that you remove REUSE from the above.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Nov 08 2006 - 06:07:34 CST