Re: help regarding creating table space

In article <35518E41.4689D73E_at_gnofn.org>, Chitiprolu Sravan Kumar <sc09_at_gnofn.org> wrote:
>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

Datafiles can change in size. This is the resize command

>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
>
>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry_at_eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the _at_#%*& DBA!