data file

[Former Member]

hi ,

u can add the data file to table space at os level by using sapdba ,is thier any restection to add minimum this much of size u have to add if u add more the 10GB is thier any effect ? and while adding the data file its take diffult value like 2gb is thier any confiquration or setting is thier ,how u can find out the setting.

can give me the step to create the sapdata file ...

Regards

sheeba

[Former Member]

Hi,

Hi

In 10g we have BIGFILE Tablespace

Datafile should be 2gb max size , diff OS support different max size of files.

If datafile size is small or 2GB

1) backup time for datafile would be less, same for restore , so downtime for db would be less.

2) If you are taking backup on disk you would not require large file system.

think it would be best to discuss this strategy with your SA and SAN administrator.

With Oracle 9i the maximum file size for an Oracle datafile, based on the DB_BLOCK_SIZEwould be as follows:

for 2k Block size, max DB File size =~ 8GB

for 4k Block size, max DB File size =~ 16GB

for 8k Block size, max DB File size =~ 32GB

for 16k block size, max DB File size =~ 64GB

for 32k block size, max DB File size =~ 128GB

ALTER TABLESPACE users

ADD DATAFILE '/u02/oracle/rbdb1/users03.dbf' SIZE 10M

AUTOEXTEND ON

NEXT 512K

MAXSIZE 250M;

Hope this helps you

Vinod

[former_member204746]

Sheeba,

you really need a SAP course.

SAPDBA is not supported anymore, go with BRTOOLS and BRSPACE.

[Former Member]

Hi Sheeba,

Use the latest BRTOOLS to manage your Database. You can add datafiles also from BRTOOLS. It's great tool from SAP to manage your database server.

ardhian