Recently, at one of my client sites I was aksed to do a client copy from Production to Development.
The procedure I followed was --
1. Checked tablespaces and increased them accordingly in Development.
2. Scheduled the export from Production. The data size is about 90 GB. It took around 1:30 hrs to export. Noted down the request numbers.
4. Logged on to the development system at OS level.
5. Added the request to buffer using tp addtobuffer
6. Started the import using command --
tp import <req.no> client= pf= u0126
7. kept on monitoring the logs in tmp directory.
Then it took 16 hrs. to complete the import.
Please assist me in analyzing the cause of this. and if any parameters need to bec hanged then waht are they? and where are they?