Re: Two Stupid Questions

From: Ron Loxton <loxtonr_at_gov.on.ca>
Date: 1997/04/04
Message-ID: <33453F8B.7F6C@gov.on.ca>#1/1

kbtr_at_sprynet.com wrote:
>
> Can anyone help me with these questions :
>
> 1) Can an Object span over one or more files?

If you mean physical files...YES. If you mean tablespace...NO.

> 2)How do I write a SQL statement to create a tablespace on which I'd
> like to store objects?

  Use the CREATE TABLESPACE command (providing you have priv to do so) then speicify the tablespace name in your CREATE TABLE, VIEW, INDEX etc command.
>
> Any help would be greatly appreciated
>

  Ron Loxton
  Database Specialist
  Ministry of Natural Resources
  Northwest Region
   Phone: (807) 473-3142 Fax: (807) 473-3116 Received on Fri Apr 04 1997 - 00:00:00 CST