tablespace..

[Former Member]

how to add tablespace in ECC 6.0?

and also from OS level

[Former Member]

Hi

Use BRTOOLS

BR0280I BRTOOLS time stamp: 2008-07-02 18.07.06

BR0656I Choice menu 1 - please make a selection

-

---

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

2

Database space management

1 = Extend tablespace

2 - Create tablespace

3 - Drop tablespace

4 - Alter tablespace

5 - Alter data file

6 - Move data file

7 - Additional space functions

8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2008-07-02 18.07.35

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2008-07-02 18.07.35

BR0657I Input menu 81 - please check/enter input values

-

---

BRSPACE options for tablespace extension

1 - BRSPACE profile (profile) ...... [initIQX.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... []

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initIQX.sap -s 20 -l E -f tsextend]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

c

Tablespace extension main menu

1 = Extend tablespace

2 - Show tablespaces

3 - Show data files

4 - Show disk volumes

5 * Exit program

6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

1

BR0280I BRSPACE time stamp: 2008-07-02 18.08.14

BR0658I List menu 302 - please select one entry

-

---

List of tablespaces for extension

Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] ExtSize[KB]

1 - PSAPSR3 17/17 84705280 17.38 69980736 16285696

2 - PSAPSR3700 8/8 16588800 77.70 3699520 1454080

3 - PSAPSR3DB 7/7 19271680 49.53 9726144 18763776

4 - PSAPSR3USR 1/1 20480 2.50 19968 1454080

5 - PSAPTEMP 1/1 839680 0.49 835584 1454080

6 - PSAPUNDO 1/1 9953280 20.64 7898816 286720

7 - SYSAUX 1/1 204800 76.81 47488 1454080

8 - SYSTEM 2/2 1402880 26.06 1037248 1454080

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your selection:

now select which one you want to increase

1

BR0280I BRSPACE time stamp: 2008-07-02 18.08.56

BR0657I Input menu 303 - please check/enter input values

-

---

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle2/IQX/sapdata5/sr3_17/sr3.data17]

2 * Last added file size in MB (lastsize) . [2048]

3 - New file to be added (file) ........... [/oracle2/IQX/sapdata5/sr3_18/sr3.data18]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [2048]

6 - File autoextend mode (autoextend) ..... [yes]

7 - Maximum file size in MB (maxsize) ..... [10000]

8 - File increment size in MB (incrsize) .. [2048]

9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle2/IQX/sapdata5/sr3_18/sr3.data18' size 2048M autoextend on next 2048M maxsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

select the value as per your requirement

then continue

Regards

Subhash

[Former Member]

Hi Subhash

He asked hw to create a tablespace not to extend a tablespace.

why do u need to add a tablespace?

Any way the options u can follow and give appropriate name and continue.

or else

CREATE TABLESPACE tablespace

DATAFILE (clause)

MINIMUM EXTENT integer(K/M)

BLOCKSIZE integer (K)

LOGGING/NOLOGGING

DEFAULT storage_clause

ONLINE/OFFLINE

PERMANENT/TEMPORARY

U can perform this with dba privileges

Note: This is not recommended

Regards

Bhaskar

Edited by: bhaskar1818 on Jul 3, 2008 10:40 AM

Edited by: bhaskar1818 on Jul 3, 2008 10:41 AM