Navicat backing up a remote Oracle database to a local

Recently, the Company development Environment Database server is very unstable, often not connected to the development of a great impact, so you want to back up the database to the local.

Since you have been working with the Navicat database, share the process of backing up the remote Oracle database with Navicat to local. Process so easy!

1, first of all, the local must install Oracle Bar ~ (nonsense!) ）

2. Create a user locally and allocate the tablespace:

CREATE TABLE Space

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 the remote database

To log in to a newly created Oracle user with Navicat:

　　

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

　　

To the local account "table" area, right-click Paste, will pop up the data Transfer dialog box, where you can select the database objects to dump: tables, views, sequences, and so on.

　　

There are some advanced options in the Advanced tab, such as when I backed up, I reported an error "[ERR] [DTF] ORA-01740: missing double quotes in identifiers", because the content in a field has a special character single quote "'", for which the effect is not too big error, you can tick " The option to encounter error continuation ".

　　

After you start, you can implement view execution progress and logs in the Infolog tab:

　　

Objects are the database objects (tables, views, sequences, and so on) that were selected in the previous step, and the records processed are the number of records that have been processed, and the transferred records are the number of records copied from the remote database to the local database; errors are errors that are encountered during the backup process (but don't be afraid, The error here is that the database structure is not affected by the fact that several records are not normalized. Because this setting has encountered an error to continue, it will be executed until the end.

Then ~ can be local visit ~ Mother no longer worry about my development time off the Network + server is not stable ~ hehe ~

"Reprint please indicate the source--Hu Yuyang" navicat Backup remote Oracle database to local "

Navicat backing up a remote Oracle database to a local