| |

VerySource

 Forgot password?
 Register
Search
View: 2054|Reply: 6

Imp does not import data

[Copy link]

2

Threads

4

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

Post time: 2020-2-13 18:30:01
| Show all posts |Read mode
Problem Description:
I want to implement online data query. I installed the oracle database and backed up the data of the tables used in the query (a total of four tables). This process went smoothly. Then, I created the database first, then created the user, and then granted DBA permissions, then logged in with this user, and imported the backed up data (a total of four tables). The first three tables were imported smoothly, but the fourth table was imported. At that time, the cursor stopped there, and I couldn't get in (one night), and it didn't report an error! I checked the capacity of my empty tables. There are 1.5G and the data of the four tables is only 350MB. The space should be large enough. Then I tried to guide only the last table. The same is not imported, and I do n’t know. It ’s because I have n’t set it up right. Please post to ask for help! !!

I tried to import the data again today. If the error is better, I posted the error!
Reply

Use magic Report

2

Threads

4

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-4-13 11:30:01
| Show all posts
When importing to the fourth table, an error occurred:
IMP-00009: Export file ended abnormally
  23131321 rows back
Reply

Use magic Report

0

Threads

71

Posts

50.00

Credits

Newbie

Rank: 1

Credits
50.00

 China

Post time: 2020-4-14 13:00:01
| Show all posts
Post the error message
Reply

Use magic Report

0

Threads

2

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-4-18 14:30:01
| Show all posts
It may be that your dump file is damaged and needs to be exported again.
Reply

Use magic Report

2

Threads

4

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-7-22 19:30:01
| Show all posts
Please help
——————————————————————————————————
When importing to the fourth table, an error occurred:
IMP-00009: Export file ended abnormally
  Line 23131321 has been rolled back
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-31 08:30:01
| Show all posts
I also encounter this problem now, I don't know how to fix it, does anyone know...
Reply

Use magic Report

0

Threads

5

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-8-31 09:30:01
| Show all posts
The dump file may be broken. . .
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list