Re: help regarding creating table space

Hi,
The ORACLE logical structure 'tablespace' is a collection of one or more physical
structures 'data files'. A datafile can be associated with only one database and once created
the datafiles cannot change in size. So inoreder to increase the tablespace one has to add
am additional datafile.
ALTER TABLESPACE tablespace
ADD DATAFILE 'datafile.ora';
for further help refer to ORACLE concepts manual chapter1,4 &5. thanks
Sravan

Dr. Gianna M. Cothren wrote:

> hello,
>
> I was trying to insert some data using SQL loader after some records,
> its saying that no table space...how do i create table space.
>
> I really appreciate any kind of help.
>
> Thank You,
> srikanth
Received on Thu May 07 1998 - 12:34:42 CEST