No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
Go up

import rows issues
Next thread: import rows issues
Prev thread: Can create 2 wallet in oracle 19c? if yes what entries need to give in sqlnet.ora for commutation?

Message Score Author Date
Hi Team I am refreshing non-production data wi...... Phuti Tsongayinwe Sep 13, 2022, 14:47
Please post the extract of both export and impor...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Sep 13, 2022, 14:52
Thanks, Michel We can ignore the duplicate and ...... Phuti Tsongayinwe Sep 13, 2022, 15:18
Thanks for the feedback. Regards Michel ... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Michel Cadot Sep 13, 2022, 16:20

Follow up by mail Click here

Subject: import rows issues
Author: Phuti Tsongayinwe, South Africa
Date: Sep 13, 2022, 14:47, 263 days ago
Os info: Oracle Solaris 11.4 SPARC.
Oracle info: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.0.0
Message: Hi Team

I am refreshing non-production data with production data but the number of rows imported is less than the number of rows exported on a table.

What might be an issue here?

Please help...

Thanks in advance...
P
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: import rows issues
Author: Michel Cadot, France
Date: Sep 13, 2022, 14:52, 263 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
Please post the extract of both export and import logs for the table along with the commands you executed.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: import rows issues
Author: Phuti Tsongayinwe, South Africa
Date: Sep 13, 2022, 15:18, 263 days ago
Message: Thanks, Michel

We can ignore the duplicate and use this thread.

I just found out that it is one of the customized scripts that we use that was causing issues.

It was the logic in the script that copied the old dump.

Thanks for your prompt reply.

Regards
P
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: import rows issues
Author: Michel Cadot, France
Date: Sep 13, 2022, 16:20, 263 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
Thanks for the feedback.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here