Skip to Content
author's profile photo Former Member
Former Member

how to add a database table space

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2007 at 07:14 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 21, 2007 at 09:24 AM

    -> 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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2007 at 03:19 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2007 at 02:16 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2007 at 04:57 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2007 at 11:18 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.