on 04-10-2007 10:06 PM
Hi,
I have one question on transporting a table.
I need to transport with data from dev to qa system.
The problem here is , in dev the table got created in table space ts01 but this tablespace does not exists in QA system (in QA this table needs to goto tablespace ts02).
How do i transport this table?
Thanks
Ram
Hi Ram,
may be the answer is a bit late, but otherwise it is may be the answer you've waited for (or may be not).
When you transport a table it only gets the table type (or class - field name tabart) from the source system. The mapping to a physical tablespace is done in the target system. In each system you could find the tables (taora, tadb6,...) which contains the mapping from the tabart to a tablespace.
For your problem this means, that ts02 in your QA system has to be of the same tabart as ts01 in DEV to receive your table from the transport.
For DB6 the tables are tadb6, iadb6 and tsdb6. tadb6 for the tables, iadb6 for indexes and tsdb6 contains the mapping between tables and indexes.
The same tables are available for Informix (till SAP Basis 6.40) and Oracle.
This is how SAP handles the database independence.
Best regards
Ralph Ganszky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rama,
you can reorganize table on development with brspace to move it on the correct tablespace, then transport the table with data. You can perform online reorganization for tables without LONG or LONG RAW fields
brspace -f tbreorg
Best regards
Giuseppe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rama,
I think you can proceed with the transport. SAP will take care of tablespace itself.
We have several systems in our landscape and I have analysis for one table in all the systems and it is different table spaces in all the systems. Tablespace should not bother you.
Please award points if issue got solved.
Regards.
Ruchit.
Hello Ruchit.
Thanks for your reply.
You have mentioned that SAP will take care of the request.Can you explain this more on how SAP will take care of this transport request?
1.tp is going to give run time error during the import process?
2.tp is going to prompt to input alternative tablespace during import?
Please explain.
Thanks
Rama
Hello Rama,
My suggestion is based on my observations with in my system landscape.
I checked for the tablespaces of couple of tables in my landscape.
In my developement system they were created on tablespace: PSAP<sid> while in QAS also they were present on table space PSAP<sid> but obviously both table spaces are different since <sid> of both the systems is different.
Now I checked the transport requests that were responsible for movement of table (structure/definition) from development to quality. I found that the imports happened successfully and without any errors. Also the transport or transport logs had no reference to table space That is why I think no issue should occur in you case also.
Have you faced any error or is just a precautionary measure that you are taking?
Regards.
Ruchit.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.