Client Import..

[Former Member]

Hi,

We need to perform the client export of PRD (300 client) system and import in QAS (300 client) i.e. quality server.

I have performed the Client export of PRD (300 client) server, which takes 4 hours and creates following two requests..

RT00025 (Client specific) = 9 GB

RX00025 (Texts) = 90 MB

Database is ORACLE on windows server 2008 R2.

Last time when we perform the client export and import procedure, that time client specific request (RT00023) is of 3 GB and it has taken 2 days to complete the client import procedure. Another thing I have seen that, there are huge redo log files created in ORAARCH folder near about 80 GB redo log files during this client import.

  So please advise me on following points..

1. How much free space require in Quality server to Import the PRD client?
2. There is any ways to speed up the client import procedure?
3. Why such amount of redo log files are created during client import?
4. How to reduce this amount of redo log files because this time client export is of 9 GB, so it creates huge amount of redo log files...

Thanks and regards,

Swapnil.

[Former Member]

At least half the time of these huge client copies/transports is spent on deleting the target tables.  If you have no other clients in QA, you can use the steps below to speed up your import considerably.

1. Identify the 25 to 50 largest tables in production.  You have to use your own judgement on how many.
2. Check the export logs and eliminate all tables from your list that were NOT exported.
3. Eliminate all tables from your list that have data in QA in a client other than your target client.  This can be done with a simple query, something like "select count(*) from <table> where mandt <> <target client>".
4. Log into your QA database and truncate (NOT delete!) the tables that are left after step 2.
5. Start the client import.

To stress again the 2 major points:

• Do not truncate any tables that are not part of the data that is being copied.
• Do not truncate any tables that have data in a client other than your target client.

And most of all: make sure you are not in production when you are doing the truncate.  (Don't ask me why. )