Navicat backs up a remote Oracle database to a local device

Recently, the company's development environment database server is very unstable and often cannot connect to it, which has a great impact on development. Therefore, we want to back up the database to a local machine. Since Navicat has been used for database operations, we will share the process of using Navicat to back up remote oracle Database Import locally. Process soeasy! 1. First, you must install oracle locally ~ (Nonsense !)

Recently, the company's development environment database server is very unstable and often cannot connect to it, which has a great impact on development. Therefore, we want to back up the database to a local machine. Since Navicat has been used for database operations, we will share the process of using Navicat to back up remote oracle Database Import locally. The process is so easy! 1. First, you must install oracle locally ~ (Nonsense !)

Recently, the company's development environment database server is very unstable and often cannot connect to it, which has a great impact on development. Therefore, we want to back up the database to a local machine.

Since Navicat has been used for database operations, we will share the process of using Navicat to back up remote oracle Database Import locally. The process is so easy!

1. First, you must install oracle locally ~ (Nonsense !)

2. Create a user locally and allocate table space:

Create a tablespace

create tablespace tbs_puhuilicaidatafile 'D:\oracle\oracledata\puhuilicai\puhuilicai_data.dbf' size 200Mautoextend on next 10M maxsize unlimitedextent management local autoallocatesegment space management auto;

Create a user and assign Permissions

create user factoring3_dev identified by danny default;grant connect to factoring3_dev;grant resource to factoring3_dev;

3. Back up remote databases

Use navicat to log on to the created oracle user:

　　

Log on to the database in the development environment and copy all the tables:

　　

In the "table" Area of the local account, right-click and paste it. The data transmission dialog box is displayed. You can select the database objects to be dumped, such as tables, views, and sequences.

　　

There are also some advanced options in the Advanced tab, such as an error "[Err] [Dtf] ORA-01740: Missing Double quotation marks in the identifier" when I backed up ", the reason is that the content of a field contains special single quotation marks ('). You can check the "Continue error" option for errors that do not have much impact on the content.

　　

After you start, you can view the execution progress and log in the Information Log Tab:

　　

Objects are the database objects (tables, views, sequences, etc.) selected in the previous step. processed records are the number of records processed, and transferred records are the number of records copied from the remote database to the local database; errors are errors encountered during the backup process (but don't be afraid, the error here is because the database structure is not affected due to irregular data records ). Because an error is set here to continue, the execution will continue until the end.

Then ~ You can access it locally ~ Mom no longer needs to worry about network disconnection and unstable servers during development ~ Haha ~

[Reprinted please indicate the source-hu Yuyang Navicat back up remote Oracle database to local]