cancel
Showing results for 
Search instead for 
Did you mean: 

how to add a database table space

Former Member
0 Kudos

hi

pls tell me how increase database table space .

in my development sever psapdev table is almost 95% is used .now i want increase the that table

my version is 4.7ee

database is oracle 9i

when am using SAPDBA command in command prompt it is given a error .

how to start a SAPDBA options.

is there any other way to start SAPDBA TOOLS.

pls help me

Accepted Solutions (0)

Answers (6)

Answers (6)

former_member190272
Active Contributor
0 Kudos

Hi

Oracle 9i not supported SAPDBA Its Work with BRTOOLS .

Brtools----->2 Space mangement -


>Extended table space Then define the table name and give the velue in MBs.

Thanks

Pankaj Kumar

former_member204746
Active Contributor
0 Kudos

Pankaj,

SAPDBA<b> <i>does</i></b> support Oracle 9... but SAP is recommending usage of BRTOOLS instead.

from Oracle 10g, no choice to use BRTOOLS.

Former Member
0 Kudos

Hi kiran,

Login as <SID>adm and the check whether run directory path is set in environmental variables.

Start SAPDBA from command prompt

1. Select option <b>c –Tablespace administration</b>

2. Select option <b>a –Tablespace</b>

Enter tablespace name [%] ==> <b>psapdev</b>

3. Select option <b>f - Alter tablespace PSAPdev Add Datafile</b>

4. Select <b>s - Start (Add datafile)</b>

regards,

kanthi

Former Member
0 Kudos

Hi Kiran,

You can add datafile in a tablespace (PSAPDEV) by running this command in sql prompt.

$sqlplus "/as sysdba"

SQL> alter tablespace PSAPDEV add datafile '/oracle/DEV/sapdata2/PSAPDEV_2/PSAPDEV_2.DATA2' size 2000 M;

But make sure that you follow the same naming convention as followed for other datafiles.

This you can ensure by running this command.

$sqlplus "/as sysdba"

SQL> select name from dba_data_files where tablespace_name='PSAPDEV';

Thanks & Regards

Praveen Verma

Former Member
0 Kudos

If you not able to add the data file using SAPDBA or BRTOOLS, you can add the data file using the SQL;

ALETER DATABASE ADD DATAFILE '<Path for the new data file >' SIZE XXXXM;

The path will have details of Tablespace.

Regards

Prabakaran.S

Former Member
0 Kudos

Before u add Datafile ...there are somethings which u need 2 check

First thing

Check for Backups..get into SQL and issue this command..select distinct status from v$backups;

it will come back saying notactive when there are no backups and it will show active if there are backups..

next thing would be to check space in the SAPDATA directories before adding datafile.

and then you may proceed to add datafiles..

go to BRTOOLS

or SAPDBA and u can do that and plz temme what error ur getting when u call SAPDBA Utility

Former Member
0 Kudos

Syed,

V$BACKUP view displays the status of online datafiles. In normal circumstances it will have the status of NOT ACTIVE, which means that online backup for the given datafile is not running, when online backups run, the tablespace is set to backup status.

Cheers,

Nisch

andreas_herzog
Active Contributor
0 Kudos

-> how about using the brtools (sapdba will not be supported any longer)?

-> just use the <sid>adm (if you're on win) or the ora<sid> to start brtools

-> follow this order: brtools -> 2 ((space management) -> 1 (extend ts) -> 3 (ts name) [enter tablespace name] -> c (continue) and so on...

GreetZ, AH