tell me about tablespace??????and waht is schemaa???????

[abhu50]

hiiiiiiiiiiii
i want to lnow some information abt tablespace and how can i increase or decreas its size ?
i always occurs with word 'SCHEMA',what is this ????tell me in brief abt SCHEMA?????
thanks in advance

reg'
abhinav

[debasisdas]

Your question is too much theoritical to explain which is beyond the scope of this discussion.You can find the solution in any good material or on any webpage by little web-searching.

[debasisdas]

to reply your second question
=============== ===========
A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes.

[rnsahu]

u can use the AUTOEXTEND clause to dynamically resize ur datafiles as needed.