Database Administrator

Oracle cross-origin access to other instance data in dblink Mode When you want to access data in another database table across local databases, dblink of the remote database must be created in the local database, dblink allows you to access data in

View All Tables and fields and Table comments. Field comments in Oracle View All Tables and fields and Table comments. Field comments in Oracle Get table: Select table_name from user_tables; // The table owned by the current user Select table_name

Environment: Oracle 10g 10.2 There is a text data in the following format: HLR_CODE HLR_TYPE REGION_CODE AREA_CODE PROV_CODE BUREAU_CODE VALID_DATE EXPIRE_DATE MODIFY_DATE1 1302309 1 565 565 551 Z00 2000-1-1 2020-12-31 23:59:59 20:22:562 1302310 1 21

Take a closer look at other functions of the Oracle nested table and make a simple arrangement. Oracle provides two methods to use nested tables:1. PL/SQL code is used as the extended PL/SQL language. (This section describes the oracle memory table

Installing the Oracle client in Linux to connect to a remote oracle host to complete data operations is a problem I will solve this time. Search for the Linux oracle keyword on google and find some articles, but it seems that the installation of

Major Data Types of database Classification All object hava a name and atype, and each object is owned by a schema. -- Query the main object types of a Database Selectobject_type, count (object_type) from dba_objects Group by object_typeorder by

1. PL/SQL Developer remember the Login Password When PL/SQL Developer is used, PL/SQL Developer needs to remember the username and password for logging on to Oracle for ease of work; Setting Method: PL/SQL Developer 7.1.2-> tools-> Preferences->

Use awrextr. SQL to export awr raw data and awrextr. SQL to export awr1. Differences between original AWR data and AWR reports  AWR raw data: The oracle Database mmon Process regularly dumps statistics from memory to disk and stores them in several

Big Data paging solution and data paging Solution 1. Writing PurposeThe paging solution is proposed to solve the performance problem when the system needs to retrieve the big data list.2 terms, definitions, and abbreviations 3. Performance Analysis

1. dump redo description For the Dump redo log example, the [ID 1031381.6] documentation on MOS is described in detail. Dump has two methods: (1) run the 'alter session' command dumpredo header. (2) run the 'alter system dump logfile' command to

View method: select name, log_mode from v $ database; The Oracle database has a redo log of the connected machine. This log records changes made to the database, such as insertion, deletion, and data update. All these operations are recorded in the

Failed to create COM Object in Vbox and vbox Recently, when using vbox, the following error occurs: failed to create COM object, and the application will be interrupted. Enter the following command in CMD: C: \ Users \ Administrator> D: D:

Insert into, replace into, insert ignore, replaceignore I recently discovered that mysql insert statements have so many usage cases. Here I will share with you. ① Insert: Insert into table_name values (); Insert into table_name (column) values

I. RDA description RDA (RemoteDiagnostic Agent) is a tool used by Oracle to collect and analyze databases. Running this tool does not change any system parameters. The data collected by RDA is comprehensive, it simplifies our daily monitoring and

Online expansion of database UNDO tablespaces and expansion of database undo tables Log on to the oracle database server with an ORACLE account Method 1: View the tablespace name and file location: select tablespace_name, file_id,

In-depth analysis of MySQL ERROR 1045 (28000) and mysql28000 After a user is created in MySQL over the past few days, the access request is denied. The ERROR code is ERROR 1045 (28000 ). I searched the internet for a long time and found many

V. Index Optimization Design 1. Manage organization Indexes The index can greatly accelerate the database query speed. The index maps the logical value in the table to a safe RowID, so the index can quickly locate the physical address of the data.

Let's look at the database -- (3) triggers and database triggers.Concept: A trigger, as its name implies, is triggered by an event. For example, when we operate a table, it will be activated for execution. When talking about triggers, another key

Let you know software development in advance (35): How to modify SQL scripts to meet your needs ?, Software Development SQL Part 1 Database SQL language How can I modify an SQL script to meet my needs?   The SQL script modification process is the

Solution: Native: listNetInterfaces: [3] When Oracle 10201 RAC is rootI. Problem 10201 when RAC is installed on OEL5, the following error is reported for the root 2nd nodes:[Root @ o10n2 install] #/oracle/product/10.2.0/crs/root. shWARNING: