Back up oracle data on the server to a Local Machine

There are many methods to back up oracle data on the server. The following describes how to back up oracle data on the server to a local machine. It is helpful for you to learn about oracle data backup.

The project will access the ORACLE database on the server. How can I create the same tablespace on the local machine?

1. log on to plsql developer with the username and password of the Connected Server, and select TOOLS ----> Export User Objects from the menu. For example:

User is the User you are currently logged on to, that is, the User name for data export. select the following check boxes and single-line buttons. For example, in the Output file column, select the location and file name of the exported file. the default file name is. SQL file.

2. Select TOOLS --> Export Tables to open the following dialog box:

Select a column in the red box. Do not select the check box. In the Output file, select the location of the exported file and write the file name. The extension does not need to be handwritten. By default, the exported file is. PVDF.

3 .. create a new user in ORACLE and assign the CONNECT and RESOURCES permissions to the user. the new username must be the same as the username on the server to be connected, because "Include Owner" is selected during export ". in this way, the user name is automatically added during the export. that is, the create table username. table name .. therefore, in the local service, use the same user name as the user name connecting to the server. after creating a new user, log on to the new user created in plsql developer. log on to the local ORACLE service. My local ORACLE service is ORA92.

4. Select FILE ---> OPEN ------> command file. Select the exported FILE name. SQL FILE, and then press the execute button (F8) to execute the SQL statement ..

5 .. TOOLS --> Import Tables, for example:

In the red box, select the file name exported above, and select Import

6 OK. You have successfully backed up the oracle data on the server to a local machine.

How to deal with oracle service loss

Implementation of Oracle redo log

Oracle Log File Management

Oracle Password File Management

Read and Write files in Oracle stored procedures