| |

VerySource

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

Two Oracle database import and export problems, urgent

[Copy link]

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-1-30 16:00:02
| Show all posts |Read mode
Now there is a problem that needs to be solved, everyone helps
The requirements are as follows:
There are two Oracle databases, A and B, they are not on the same server
Now we need to import the view from A to machine B, and export from A at 12pm every night.
After importing to B, if you can write a program on Oracle, can it be achieved without using other development languages
Reply

Use magic Report

0

Threads

71

Posts

50.00

Credits

Newbie

Rank: 1

Credits
50.00

 China

Post time: 2020-3-7 14:00:02
| Show all posts
view?
Reply

Use magic Report

0

Threads

13

Posts

10.00

Credits

Newbie

Rank: 1

Credits
10.00

 China

Post time: 2020-3-8 22:15:02
| Show all posts
What's the use of a guided view?
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-3-22 23:15:01
| Show all posts
If the table is not imported, the data cannot be found only in the guide view.
Reply

Use magic Report

0

Threads

4

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-7-14 07:45:01
| Show all posts
The view does not need to be guided, build a dblink from B to A, and then create a view on B to access the table on A through dblink, the problem is ok!
Reply

Use magic Report

1

Threads

7

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

Post time: 2020-7-16 15:45:01
| Show all posts
marceau543makes sense! No table view is useless.
Reply

Use magic Report

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-8-2 13:45:01
| Show all posts
The a library is slow, so it needs to be imported into the b library
a library provides a view
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