Oracle backs up the database by using SQL statements

Updated on technology 2024-02-23
4 answers
  1. Anonymous users2024-02-06

    Oracle does not have SQL statement backup, only exp export or RMAN backup, are not SQL, RMAN is a standard block backup, the premise is that the database must be archived, and then RMAN backup can be carried out, this method can be used for databases with a large amount of data, the speed will be relatively fast, the specific method can be checked from the Internet, it is not very difficult, but it is more cumbersome, there is an exp export, this is to directly export the table in the database to the city dmp file, The specific syntax is:

    exp user password@dbsid file=d: The name of the backup destination folder. dmp log=d: The name of the destination folder for backup. log owner = username.

    The above statement needs to be executed from the cmd command line, if you want to export whichever user you want, you can export any user, as long as you can use SQL statements to connect to the database, you can use it, no matter which machine you are on.

  2. Anonymous users2024-02-05

    Export as a file, exp username password@databasename file=path filename. dmp

    Import on imp username password @ database name file=path filename. dmp

  3. Anonymous users2024-02-04

    Export exp username password @ database name file=path filename. dmp

    Import imp username password @ database name file=path filename. dmp full = y

  4. Anonymous users2024-02-03

    1. First of all, confirm whether the services related to Oracle on the Oracle server have been started normally.

    2. Then close the plsql, let the connection exit first, make sure to disconnect all connections to the database, if there are clients in the database that are connecting, there may be an exception when backing up.

    3. Then open the cmd command prompt window, enter the command to back up the database, the xp command is followed by the username and password, file is the path of backup, owner is the username of the database, and press the enter key to wait for the backup.

    4. Be patient. When the data is exported, a prompt will appear in the cmd window, which means that Yushan has completed the database backup and export action.

    5. At this time, find the file save path set in the fourth step in the computer, as shown in the screenshot below, you will find that there is an additional DMP file, this file is the backup file that my old demolition leaders need.

Related questions
SQL statement issues
5 answers2024-02-23

F get domain contrast is a formatting function (should be written by yourself), the first parameter (arg prod spec id) according to the second parameter (120) formatting and return the result to the v bill code, according to the function naming method, the above ** should be the standard format for getting the date.

SQL Statement Optimization Questions, Several Methods of SQL Optimization Interview
5 answers2024-02-23

With a view or an index.

create index >>>More

Statements in Oracle stored procedures
4 answers2024-02-23

The solution is as follows: 1. The create global temporary table t temp statement is to create a temporary table, there are two kinds of temporary tables created in oracle, one is transaction-level and the other is session-level, when the creation of temporary table statement is followed by on commit delete rows, it means that the temporary table is transaction-level, and when on commit preserve rows it means that the temporary table is session-level. >>>More

Is this my understanding of the order by of the sql statement correct?? (Rookie Question).
15 answers2024-02-23

1.It's interesting to understand, but the reality should be: if there are more than two fields after order by, then all the records in the result set are sorted by the previous field, and the same part of the previous field is sorted by the next field. For example: >>>More

Problems with select statements in SQL?
4 answers2024-02-23

Generally refers to indexing. You don't have to.