Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Archive log mode is disabled.
SQL> SELECT LOG_MODE FROM V$DATABASE;
LOG_MODE
---
NOARCHIVELOG
Log:
4 ETW675 end import of "R3TRTABUPPMIX".
3 ETW674Xstart import of "R3TRTABUPPMPX" ...
4 ETW000 no entries from PPMPX (*) deleted (table is empty).
4 ETW000 no entries from PPMPX (*) deleted (table is empty).
4 ETW675 end import of "R3TRTABUPPMPX".
3 ETW674Xstart import of "R3TRTABUPPOIX" ...
3WETW019 No memory for space allocation left ("1855000000").
4 ETW000 twrtab reached memory limit; memory usage 1850000000
Thanks and regards,
Satya
| | | ---------------Original Message---------------
From: satyanarayana buddarapu
Sent: Saturday, September 17, 2011 1:01 PM
Subject: Client Import - TP Running
Hi,
We were performing client export/import from PRD to QA.
Export is successful (21/2 hours for 150 GB size of DB).
The tp request successfully added to buffer after the import is running for longer period.
The size of datafile is 12GB around.
In STMS import status is showing as import running(truck).
tp and r3trans for running at OS level.
Import monitor log
target client=410
maximum return code: 8888 - tp running
(pr1kt00055, ) running main report.
tp SLOG:
START TRANSMIT BUFFER ENTR QA1 g 20110917070813
STOP TRANSMIT BUFFER ENTR QA1 g 0000 20110917070813
START TRANSMIT BUFFER ENTR QA1 g 20110917071331
STOP TRANSMIT BUFFER ENTR QA1 g 0000 20110917071331
START TRANSMIT BUFFER ENTR QA1 g 20110917071433
STOP TRANSMIT BUFFER ENTR QA1 g 0000 20110917071433
START TRANSMIT BUFFER ENTR QA1 g 20110917071434
STOP TRANSMIT BUFFER ENTR QA1 g 0000 20110917071434
Please let us know whether the tp import is running or not.
Please suggest the time taken to import in STMS.
Thanks and regards,
Satya |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |   _.____.__ |
