on 12-01-2008 12:01 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
you should continue posting on your original topic and not open a new one.
thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.