datafile adding procedure

[Former Member]

hi,

how can i add datafiles to table spaces and when can i add(except SAPDBA tool)

please give me step by step procedure for adding.

thanks in advance

vinnu

[Former Member]

Vinay

When u ask some thing u shd be specific.

Asw to ur question how can i add datafile to TS

connect sqlplus as sysdba and issue command

sql>alter tablespace <name>

add datafile 'c:\xx\<name>.dbf' size 4M autoextend off; this is example

When u can add whenever ur tablespace is full or going to full.

U can search in net for all methods and commands

vinod

[Former Member]

Hello,

I think I do not understad totally the question.

How can you add datafiles?

-> SAPDBA ( obsolete tool )

-> BRSPACE

-> SQLPLUS

When?

This is the part I do not understand. When you can add a datafile?

Always, if you have enough free space.

As you want step by step

1) open tahiti.oracle.com

2) select "Oracle9i documentation, Release 2 (9.2). " ( if you are in oracle 9i )

3) Select "list of books"

4) go to "SQL Reference" and select the PDF or "Contents"

5) Check the syntax for "ALTER TABLESPACE" and adjust it to your needs ( I will not specify here the command as I do not know your needs )

[Former Member]

br*tools have some restrictions on the directory structure in order to work fine (for example one datafile per directory).

There for it is advisable to use brspace to create a new datafile. It will automatically keep you within those restrictions (otherwise a restore may fail).

Peter