postgres to oracle replication

operations, the direct replication of the source Oracle database data into the target database, this way is faster, but the feeling is also error-prone, data import errors can continue to import other table data. Directly select a table from the source library, press CTRL + C, select the table in the target library, press CTRL + V to select the data tables, views, and so on to copy. 2.Navicat Export, impor

Iv. Clear Streams Replication environment On the one hand is to facilitate the test environment behind the construction, on the one hand because the 10g streams replication environment is very simple to remove, so this is the last section of this chapter. To remove the entire replication environment, simply log on to the Streams Administrator account on the sou

1. Method One: Create DBL (data base link)CREATE Public Database link Data link name CONNECT to login user name identified by password USING ' (DESCRIPTION =(Address_list =(address = (PROTOCOL = TCP) (HOST = IP address of the other Oracle server) (port = port number)))(Connect_data =(service_name = Other Oracle Server service name)))Of course, you can also use tools such as Toad, it is simple, the new dbl c

Resolves an oracle EBS out-of-report non-replicating issue suddenly think of a long time ago colleagues mentioned that EBS made a report cannot be copied.where the upper-right corner font size can be set:Needless to say, let's solve the problem that can't be duplicated. Click Tools-Copy files.Pop up a window, we select Microsoft Excel and browser separately, look at the effect.Microsoft Excel prompts you to download a text file. After opening.Browser