Database Administrator

1. Create a tablespace in Oracle Create tablespace tianzh Logging Datafile'/Opt/oracle/oradata/dqjz/jwzh01.dbf' Size 30720 m Autoextend on Next 50 m maxsize 32768 m Extent management local; 2. Expand the tablespace based on the original

Summary: in Oracle, a user is granted the permission to access all tables of the user. For example, grant the query permission of all tables under the scott user to the T User. Create Or Replace ProcedureGrant_selectAll_ SQLAs The_c1Integer; The_

Oracle Data Pump I. Role of Data Pump: 1. implement logical backup and logical recovery 2. move objects between database users 3. move objects between databases 4. Implement table space Transfer Ii. Differences between Data Pump

Because the business needs to add a sequence every month, it is expected to use the job to create a regular one year each time. Some problems encountered when writing this job are recorded here. Step 1: Write the stored procedure for creating a

This is the case. One of my servers installed Oracle11gR201, And the grid Infrastructure and Database software were respectively installed by the Grid and oracle users. As a result, when using the dbca tool to create a Database, when the progress

1. Create a connection userMkuser id = 1028 pgrp = db2user1 groups = db2user1 home =/home/fmusx core =-1 data = 491519 stack = 32767 rss =-1 fsize =-1 fmusx 2. Create a Development DatabaseDb2 create database SX3 automatic storage yes

In Oracle 11g, use sysdba to connect to ASM.SQL> conn/as sysdbaSQL> alter diskgroup DATA mount;Alter diskgroup DATA mount*ERROR at line 1:ORA-15032: not all alterations saved medORA-15260: permission denied on ASM disk groupORA-15260: permission

After installing Oracle 11g rac. the scanip is configured in ora, but it cannot be accessed. The error is that the target host does not exist. It has been tossing for a long time and I have not figured it out. Later I found that local_listener is

1. explain extended select .....Decompile the execution plan into a SELECT statement and run show warnings to obtain the query statement optimized by the MYSQL optimizer. 2. explain partitions select ....Used to EXPLAIN the Partition Table 3.

In an application system, the function of running orqcle SQL is provided. Simple SQL statements run normally, and complex SQL statements with subqueries often encounter errors. However, this statement runs in dql plus. For example: ORA-00907: The

The archive path of rac is modified. If the archive path is not modified, an error is reported when the server is started today. ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated This error is caused by a problem

The following error occurs when an extract is started today: 22:41:02 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, e1_rks2. prm: cocould not find archived log for sequence 10770 thread 1 under default destinations SQL , error retrieving

-- In this case, you need to add several constraints to the table. The syntax for adding constraints is as follows:-- Alter table name add constraint name constraint type (constraint field)-- Delete constraints:-- Alter table book drop constraint

Send a shotgun to a table: (1) insert into table_name [(column [, column...])] select_statementOnly one table can be inserted at a time, but the performance is higher than writing multiple insert statements. In addition, Oracle also provides create

The cache mechanism simply caches the SQL text and query results. If the same SQL statement is run, the server directly retrieves the results from the cache without parsing and executing the SQL statement. If the table is changed, all cache queries

The following error is reported when you log on to a node in Oracle using an ORACLE account. An error occurred while loading or saving configuration information in gnome-session. Some of your configuration settings may not work properly. An error

Median refers to the data that is arranged in order of size to form a series that is located in the middle of the series. The median value is represented by Me. According to the definition of median, half of the data studied is smaller than the

Exact match For a single key-Value Pair: {"age": 28}, all documents whose "age" value is 28 are returned. Multiple key-value pairs: {"username": "tom", "age": 28} combine multiple query conditions, equivalent: condition 1 AND condition 2 AND...

How to generate mysql-bin.000001 file and its processing methodFiles such as mysql-bin.000001, mysql-bin.000002 are database operation logs, such as updating a table, or deleting some data, even if the statement does not match the data, the command

The installation of MySQL 5.5.27 is somewhat different from that of MySQL in the past, as follows: 1. Download cmakeTar./ConfigureMake & make install 2. groupadd mysqlUseradd-g mysqlMkdir-pv/usr/local/mysql/data 3. tar