Re: How Do I create a TablesSpace in Oracle 7.3.3 on an NT Box??

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/10/09
Message-ID: <343CC704.3779E939@gatwick.geco-prakla.slb.com>#1/1

Bruce Kempthorne wrote:

> I am using oracle 7.3.3 on an NT server. I have created a database and
> want to create tablespaces before running a script to create tables.
> Can anyone show me how to CREATE TABLESPACES??

Log into SQL*Plus using the SYS or SYSTEM accounts and type the command;

create tablespace <tablespace_name>
datafile '<datafile_name_inc_full_path>' size <desired_size>K;

Cheers,

Ian Received on Thu Oct 09 1997 - 00:00:00 CDT

This message: [ Message body ]
Next message: Vittorio Turchetti: "SQL*Net connection thru a firewall"
Previous message: Victor L. Artchakov: "Re: How Do I create a TablesSpace in Oracle 7.3.3 on an NT Box??"
In reply to: Bruce Kempthorne: "How Do I create a TablesSpace in Oracle 7.3.3 on an NT Box??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US