cancel
Showing results for 
Search instead for 
Did you mean: 

Reorgenization Problem

Former Member
0 Kudos

Dear Experts ,

I am facing some problem in reorgenization , I have gone through the sap note - 646681 . we are using mySAP ECC5 with Oracle 9.2.0.6 on windows 64 bit server .I am little bit confused in the below procedure

1.Server hard disk was full so I have added an USB hard disk .

2. I have to reorgenize PSAPDEV tablespace with LONG fields .

3. I have created one tablespace PSAPDEVD located on USB Hard disk.

4. Started the online reorgenization.I am using brtools to do it , so ddl script is automaticaly generated .

5. Stopped the SAP through MMC

5. after successful complition of online reorgenization I have started the offline reorgenization for LONG fields ,in the offline dump file path to USB Drive .

6. After succesffully completion of offline Export . I have dropped the original Table space PSAPDEV .

7. Now started the ddl.sql first script .

8. After first ddl.sql script I have started the import process .

9. After successfuly completiong of import Started the another two sql scripts .

10. Moved the tablespace from USB drive to Local Hard drive .

Q1. should I start reorgenization again for to remain the tablespace name orginal , because this time the tablespace name is PSAPDEVD and the original tablespace name was PSAPDEV .

Rename is not supported in Oracle 9.2.0.6 .

Q2. in present situation sap is started but giving dumps .

Q.3. Pl. advice me if I am wrong any where .

I am already in touch with Eric Brunelle (He has also given the great support to me ).

Pl. help me

Thanks

Neeraj

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Neeraj,

Please check below point as per note 646681.

1. Creating a new target tablespace

brspace -f tscreate -t <new_tsp> -s <size> -a yes -m <max_size>

-i <incr_size> -l {all <old_tsp>} Make sure that the new tablespace is large enough to enter all tables.

If necessary, extend the tablespace with additional files or use

Auto-Extend.

brspace -f tsextend -t <new_tsp> -s <size> -a yes -m <max_size>

-i <incr_size>

Caution: Do not forget to set the " -l" option (table data class), so

that the new tablespaces copy all standard SAP data classes. If you

only want to move all tables from one or several (but not all)

tablespace[s] into a new tablespace, instead of "all", set the name[s]

of the old tablespace[s] in the "-l" option: "-l

<old_tsp_name>[,<old_tsp_name>,...]". The new tablespace thus copies the

data types assigned to the old tablespace[s]. However, if you only want

to move individual tables into a new tablespace, do not set this option.

As a result, BRSPACE automatically generates a new data class that is

assigned to the individual tables during the reorganization.

I have question for you while creating PSAPDEVD tablespace have you used the above option.

How you have created tablespace? can you provide that command?

As per the above statement in note if you use -l option while creating tablespace it shd assign data class to new tablesapce automatically.

Can you tell us what short dumps you are getting?

Good Luck,

Atil

Former Member
0 Kudos

Hi,

Thanks for your reply , I have created the tablespace with -l option , attaching the log file for your refference.

SAP Dump file

http://rcpt.yousendit.com/630060202/1cd517f8c9ca75bf057010c69d6f8077

Sap tablespace creation

http://rcpt.yousendit.com/630062112/dfd4763284a76eaa35324b245118cd47

Sap Export Import Dumps

http://download.yousendit.com/Q01GSlIySytVbStGa1E9PQ

Thanks

Neeraj

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

you should continue posting on your original topic and not open a new one.

thanks.

Former Member
0 Kudos

ok sir