Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the difference between Dameng database and oracle data". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. below, please follow the editor's train of thought to study and learn what are the differences between Dameng database and oracle data.

1. The difference between landing

Oracle: if you forget your sys password, you can use operating system authentication to log in and change your password.

Dm: Dameng database cannot log in if you forget the password of sysdba.

2. The status of the database

The states of oracle:oracle are shutdown, nomount, mount and open.

Dm: the Damon database has shutdown, mount, open and suspend states, adds a pending state, and can be switched directly to mount state in the open state. Oracle is not allowed.

3. The difference between creating data file size units

Oracle: you can specify the unit of size, kb,mb,gb, when creating a tablespace to specify a data file

Dm: Dameng cannot write the unit when creating the specified data file in the tablespace, or it will report an error. The default unit is mb.

4. The difference of RMAN backup

Oracle:oracle 's RMAN can be used for hot backup.

Dm: the RMAN of Dameng can only be used for cold backup.

5. The difference between the case of table space

Oracle: alter tablespace xxx tablespace names are not case-sensitive when you create a tablespace and manipulate it.

Dm: if the tablespace name created in Dameng operation is lowercase, it needs to be enclosed in double quotation marks

6. The difference between archiving

If oracle:oracle does not specify an archive path, it is stored in the recovery directory by default.

Dm: you need to specify the archive path, size and upper limit size for Dameng.

7. Differences in execution of stored procedures

The command for oracle:oracle to execute a stored procedure is the name (parameter) of the exec stored procedure.

Dm: the command for Dameng to execute the stored procedure is the call stored procedure name (parameter).

8. The difference between executing scripts

Oracle:oracle executes the command script under sqlplus using @.

Dm: Dameng executes the script using start.

9. Parameter difference

The command to modify parameters in oracle:oracle is alter system set xxxx=xxx

Dm: the command to modify the parameters of Dameng is sp_set_para_value (x).

10. The difference between default tablespace names

Oracle: the default tablespace for user data is the user tablespace

Dm: the name of the table space where the default user data is stored is the main table space.

Thank you for your reading, the above is the content of "what is the difference between Dameng database and oracle data". After the study of this article, I believe you have a deeper understanding of the difference between Dameng database and oracle data. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.