on 04-21-2007 5:23 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.