I have tried to create table-space with "TEST" ,but the system is NOT allowing and we have to create Table space starting with PSAP and TBS name should be minimum 7 character length.
Here is the step to create NEW table space in Oracle SAP Database.
SERVER_NAME:oraTEST 35> brtools
BR0651I BRTOOLS 7.00 (32)
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.10
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
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.13
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.13
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
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:
2
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.15
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.15
BR0657I Input menu 82 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for create tablespace
1 - BRSPACE profile (profile) ...... [initTEST.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 initTEST.sap -s 20 -l E -f tscreate]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.19
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.19
BR0681I Enter string value for "tablespace" []:
PSAPTEST
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.27
BR0683I New value for "tablespace": 'PSAPTEST'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.27
BR0657I Input menu 82 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for create tablespace
1 - BRSPACE profile (profile) ...... [initTEST.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPTEST]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTEST.sap -s 20 -l E -f tscreate -t PSAPTEST]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.33
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initTEST.sap -s 20 -l E -f tscreate -t PSAPTEST'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.33
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.35
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.00 (32)
BR1002I Start of BRSPACE processing: setcdrgt.tsc 2015-05-04 13.46.35
BR0484I BRSPACE log file: /oracle/TEST/sapreorg/setcdrgt.tsc
BR0280I BRSPACE time stamp: 2015-05-04 13.46.35
BR1009I Name of database instance: TEST
BR1010I BRSPACE action ID: setcdrgt
BR1011I BRSPACE function ID: tsc
BR1012I BRSPACE function: tscreate
BR0280I BRSPACE time stamp: 2015-05-04 13.46.35
BR0657I Input menu 305 - please check/enter input values
-------------------------------------------------------------------------------
Main options for creation of tablespace in database TEST
1 - Tablespace name (tablespace) ......... [PSAPTEST]
2 - Tablespace contents (contents) ....... [data]
3 - Segment space management (space) ..... [auto]
4 # Database owner of tablespace (owner) . []
5 # Table data class / tabart (class) .... []
6 - Data type in tablespace (data) ....... [both]
7 # Joined index/table tablespace (join) . []
8 ~ Uniform size in MB (uniform) ......... []
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2015-05-04 13.46.40
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2015-05-04 13.46.40
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPTEST (1. file)
1 - Tablespace file name (file) .......... [/oracle/TEST/sapdata3/test_1/test.data1]
2 ~ Raw disk / link target (rawlink) ..... []
3 - File size in MB (size) ............... [100]
4 - File autoextend mode (autoextend) .... [no]
5 # Maximum file size in MB (maxsize) .... []
6 # File increment size in MB (incrsize) . []
7 - SQL command (command) ................ [create tablespace PSAPTEST extent management local autoallocate segment space management auto datafile '/oracle/TEST/sapdata3/test_1/test.data1' size 100M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2015-05-04 13.46.51
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2015-05-04 13.46.51
BR1091I Next data file can be specified now
BR0675I Do you want to perform this action?
BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
n
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR0257I Your reply: 'n'
BR0678I The action will be skipped...
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR0370I Directory /oracle/TEST/sapreorg/setcdrgt created
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR0319I Control file copy created: /oracle/TEST/sapreorg/setcdrgt/cntrlTEST.old 16302080
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR0370I Directory /oracle/TEST/sapdata3/test_1 created
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR1089I Creating tablespace PSAPTEST...
BR0280I BRSPACE time stamp: 2015-05-04 13.46.55
BR1016I SQL statement 'create tablespace PSAPTEST extent management local autoallocate segment space management auto datafile '/oracle/TEST/sapdata3/test_1/test.data1' size 100M autoextend off' executed successfully
BR1060I Tablespace PSAPTEST created successfully with file: /oracle/TEST/sapdata3/test_1/test.data1 100M
BR0280I BRSPACE time stamp: 2015-05-04 13.46.55
BR0340I Switching to next online redo log file for database instance TEST ...
BR0321I Switch to next online redo log file for database instance TEST successful
BR0280I BRSPACE time stamp: 2015-05-04 13.46.55
BR0319I Control file copy created: /oracle/TEST/sapreorg/setcdrgt/cntrlTEST.new 16302080
BR0280I BRSPACE time stamp: 2015-05-04 13.46.55
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2015-05-04 13.47.02
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2015-05-04 13.47.08
BR0258W Wrong reply: 'y'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2015-05-04 13.47.11
BR0257I Your reply: 'y'
BR0260E BRSPACE cancelled by user
BR1008I End of BRSPACE processing: setcdrgt.tsc 2015-05-04 13.47.11
BR0280I BRSPACE time stamp: 2015-05-04 13.47.11
BR1007I BRSPACE terminated with errors
###############################################################################
BR0292I Execution of BRSPACE finished with return code 4
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRTOOLS time stamp: 2015-05-04 13.47.11
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRTOOLS time stamp: 2015-05-04 13.47.13
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2015-05-04 13.47.15
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2015-05-04 13.47.15
BR0654I BRTOOLS terminated with errors
SERVER_NAME:oraTEST 36>
Here is the step to create NEW table space in Oracle SAP Database.
SERVER_NAME:oraTEST 35> brtools
BR0651I BRTOOLS 7.00 (32)
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.10
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
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.13
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.13
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
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:
2
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.15
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.15
BR0657I Input menu 82 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for create tablespace
1 - BRSPACE profile (profile) ...... [initTEST.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 initTEST.sap -s 20 -l E -f tscreate]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.19
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.19
BR0681I Enter string value for "tablespace" []:
PSAPTEST
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.27
BR0683I New value for "tablespace": 'PSAPTEST'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.27
BR0657I Input menu 82 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for create tablespace
1 - BRSPACE profile (profile) ...... [initTEST.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPTEST]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTEST.sap -s 20 -l E -f tscreate -t PSAPTEST]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.33
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initTEST.sap -s 20 -l E -f tscreate -t PSAPTEST'
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.33
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2015-05-04 13.46.35
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.00 (32)
BR1002I Start of BRSPACE processing: setcdrgt.tsc 2015-05-04 13.46.35
BR0484I BRSPACE log file: /oracle/TEST/sapreorg/setcdrgt.tsc
BR0280I BRSPACE time stamp: 2015-05-04 13.46.35
BR1009I Name of database instance: TEST
BR1010I BRSPACE action ID: setcdrgt
BR1011I BRSPACE function ID: tsc
BR1012I BRSPACE function: tscreate
BR0280I BRSPACE time stamp: 2015-05-04 13.46.35
BR0657I Input menu 305 - please check/enter input values
-------------------------------------------------------------------------------
Main options for creation of tablespace in database TEST
1 - Tablespace name (tablespace) ......... [PSAPTEST]
2 - Tablespace contents (contents) ....... [data]
3 - Segment space management (space) ..... [auto]
4 # Database owner of tablespace (owner) . []
5 # Table data class / tabart (class) .... []
6 - Data type in tablespace (data) ....... [both]
7 # Joined index/table tablespace (join) . []
8 ~ Uniform size in MB (uniform) ......... []
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2015-05-04 13.46.40
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2015-05-04 13.46.40
BR0657I Input menu 306 - please check/enter input values
-------------------------------------------------------------------------------
Space options for creation of tablespace PSAPTEST (1. file)
1 - Tablespace file name (file) .......... [/oracle/TEST/sapdata3/test_1/test.data1]
2 ~ Raw disk / link target (rawlink) ..... []
3 - File size in MB (size) ............... [100]
4 - File autoextend mode (autoextend) .... [no]
5 # Maximum file size in MB (maxsize) .... []
6 # File increment size in MB (incrsize) . []
7 - SQL command (command) ................ [create tablespace PSAPTEST extent management local autoallocate segment space management auto datafile '/oracle/TEST/sapdata3/test_1/test.data1' size 100M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2015-05-04 13.46.51
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2015-05-04 13.46.51
BR1091I Next data file can be specified now
BR0675I Do you want to perform this action?
BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
n
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR0257I Your reply: 'n'
BR0678I The action will be skipped...
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR0370I Directory /oracle/TEST/sapreorg/setcdrgt created
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR0319I Control file copy created: /oracle/TEST/sapreorg/setcdrgt/cntrlTEST.old 16302080
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR0370I Directory /oracle/TEST/sapdata3/test_1 created
BR0280I BRSPACE time stamp: 2015-05-04 13.46.54
BR1089I Creating tablespace PSAPTEST...
BR0280I BRSPACE time stamp: 2015-05-04 13.46.55
BR1016I SQL statement 'create tablespace PSAPTEST extent management local autoallocate segment space management auto datafile '/oracle/TEST/sapdata3/test_1/test.data1' size 100M autoextend off' executed successfully
BR1060I Tablespace PSAPTEST created successfully with file: /oracle/TEST/sapdata3/test_1/test.data1 100M
BR0280I BRSPACE time stamp: 2015-05-04 13.46.55
BR0340I Switching to next online redo log file for database instance TEST ...
BR0321I Switch to next online redo log file for database instance TEST successful
BR0280I BRSPACE time stamp: 2015-05-04 13.46.55
BR0319I Control file copy created: /oracle/TEST/sapreorg/setcdrgt/cntrlTEST.new 16302080
BR0280I BRSPACE time stamp: 2015-05-04 13.46.55
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2015-05-04 13.47.02
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2015-05-04 13.47.08
BR0258W Wrong reply: 'y'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2015-05-04 13.47.11
BR0257I Your reply: 'y'
BR0260E BRSPACE cancelled by user
BR1008I End of BRSPACE processing: setcdrgt.tsc 2015-05-04 13.47.11
BR0280I BRSPACE time stamp: 2015-05-04 13.47.11
BR1007I BRSPACE terminated with errors
###############################################################################
BR0292I Execution of BRSPACE finished with return code 4
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRTOOLS time stamp: 2015-05-04 13.47.11
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRTOOLS time stamp: 2015-05-04 13.47.13
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2015-05-04 13.47.15
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2015-05-04 13.47.15
BR0654I BRTOOLS terminated with errors
SERVER_NAME:oraTEST 36>
No comments:
Post a Comment