ADD datafile

[Former Member]

Dear Experts,

I am using SAP 4.7 with oracle 8.1 on Windows 200 server.

I want to extended data file and Add data file. I think it can be via SAPDBA ,But I never use this one . So please explain me step-by step . so that I can ADD or Extended datafile ? and It can be Online , mean no user will effect on his work.

Please give me so step by setp .

thanks

MANU

[lbreddemann · Accepted solution]

Hi Manu,

Oracle 8.1 -> desupported

Windows 2000 -> desupported

SAPDBA -> not maintained anymore

You're running pretty outdated software there...

Anyhow, yes you can use SAPDBA to add a datafile.

Just start SAPDBA.

You'll get a menu then, similar to this:

         SAPDBA V6.20 - SAP Database Administration - on WIN NT 5.1
________________________________________________________________________


                    ORACLE version: 9.2.0.8.0
                    ORACLE_SID    : IPDB
                    ORACLE_HOME   : c:\ORACLE\IPDB\920
                    DATABASE      : db status unknown


          a - Startup/shutdown instance    h - Backup database
          b - Instance information         i - Backup offline redo logs
          c - Tablespace administration    j - Restore/recovery
          d - Reorganization               k - Additional functions
          e - Export/import                l - Show/cleanup
          f - Archive mode                 m - User and security


          q - Quit

          Please select ==>  

Choose "c . Tablespace administration" and "f - Alter tablespace add data/temp file" in the following menu screen.

That should be easy enough.

Best regards,

Lars

[Former Member]

Hi Manu,

Not sure you can data datafile online.I think sap will be down at this time.

Login as sidadm, start-run->sapdba

SAPDBA options will come choose option c then option a to provide tablespace name then chose option extend table space option f then again option c and give the value for the table space and option s to start. After this it will ask you to take the backup of newly created datafile you can come back or can take backup.

Regards

Ashok

[lbreddemann]

>

> Not sure you can data datafile online.I think sap will be down at this time.

WHAT?? How the heck do you come to this understanding?

No, adding datafiles can and should be done online - while Oracle and SAP are running as usual.

Sorry - but please : [Space Management with BR*Tools|http://help.sap.com/saphelp_nw70/helpdata/EN/a7/8db6c2ebc5384eb82e5f99e49600d6/frameset.htm]

This link is about the current tools for DB administration - the BRTOOLS.

For SAPDBA questions check: [Tablespace Administration with SAPDBA|http://help.sap.com/saphelp_webas630/helpdata/en/0d/d2f94b4a0c11d182b80000e829fbfe/content.htm]

regards,

Lars