Database Administrator

Create order Path: Order Management> Orders, Returns> Sales Orders Enter order header information, customer, order type, sales personnel Enter order body information, enter materials, quantity... Then, Book Order, after the Order Book, you

Oracle Streams has been configured for a long time. For some reasons it is not officially used, you need to completely clear its configuration information. Streams consists of three parts: capture, progapation, and apply, and some basic

1. Full database backup Note: rman can back up the data files on asm to the file system or restore them. RMAN> run {Allocate channel c1 type disk maxpiecesize = 500 m;Backup current controlfile format '+ dgasm/backup/ctl _ % d _ % s ';Backup full

PostgreSQL database provides a lightweight stress testing tool called pgbench, which is actually an executable file with compiled scalability. It is described as follows.Environment:CentOS 5.7 (final)PG: 9.1.2Vmware 1, 8.0Database parameter:

Starting from 11.2.0.2, Redundant Interconnect with Highly Available IP (HAIP) was added to the cluster software Grid Infrastructure (GI) of Oracle to achieve high availability and load balancing for the private network of the cluster.Before 11.2.0.2

1. Modify the hosts record of the Client Server192.168.1.240 Rac01194251.241 Rac02192.168.1.242 Rac01-vip192.168.1.243 Rac02-vip108.88.3.240 Rac01-priv108.88.3.241 Rac02-priv2. Create a New Tnsname record editing client: tnsnames. ora file, which is

The data in the Top Ten List is stored in the table fnd_user_shorttop_objects. The data is read from the table during login and displayed. When the user exits, the following APIs are used: FND_SIGNON.UPDATE_NAVIGATOR updates the new TOP Ten List to

Use Xshell to connect to a remote Linux database server. When you switch to the sqlplus console and enter an error character, ^ H is displayed when you use the rollback key to modify the character. Solution:$ Stty erase ^ H: erase is used to delete

Delete undo tablespace report ORA-01548 When exporting data with expdp, the following error occurs: C: \ Documents ents and Settings \ TEMP> expdp scott/tiger DUMPFILE = scott. dmp DIRECTORY = du Mp SCHEMAS = scott Export: Release

View the Oracle database version· SQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionPL/SQL Release

Oracle supports full-text retrieval from 7.3, that is, you can use the ConText option of the Oracle server to complete text-based queries. Specifically, you can use wildcard search, fuzzy match, related classification, approximate search,

The Flashback function and experiment are a little old. I will share the experiment diary from the previous two years. 1. Set flashback Parameters SQL> conn/as sysdba;Connected.SQL> archive log listDatabase Log mode non-archive ModeDisable automatic

The purpose of this article is to read and understand your own books and use this picture to explain. If there are any mistakes, I hope you can correct them and share them with us for the purpose of mutual discussion. First, let's introduce the

1. How to enable the autotrace function of sqlplus? [Pl/SQL dev does not support this function]Log On with the sys user and perform the following steps:(1 )@? \ Rdbms \ admin \ utlxplan -- create a plan_table table(2) There is no synonym for

Environment: Oracle 10g RHEL 5.8Description: BBED is called data block browsing and editing. Deep Learning of Oracle block and disaster recovery in special circumstances.1. Compile the connection:Cd $ ORACLE_HOME/rdbms/libMake-f ins_rdbms.mk $

Install some required linux packages: Yum install gcc-c ++ gcc-g77 autoconf automake zlib * fiex * libxml * ncurses-devel libmcrypt * libtool-ltdl-devel * libevent To install mysql, you must download the mysql installation package. The

1. Import ModuleImport MySQLdb >>> help ('mysqldb ')>>> Help ('mysqldb. cursors ')2. Connect to the databaseConn = MySQLdb. Connection (host = 'host', user = 'user', passwd = 'Password', db = 'dbname', port = port) For example: Conn = connect (host =

In the CBO era, the execution plan of SQL statements relies entirely on the statistical information stored in the data dictionary and the computing formula parameters of Optimizer. From 9i to 11gR2, we say that the CBO optimizer has been mature and

Oracle 9i provides the dbms_redefinition package to implement online redefinition of database tables. In practical applications, we can use this package:(1) convert heap tables and partitions. (2) recreate the table to reduce HWM. 10 Gb shrink, 9i

Oracle Database WEBDB performs a remote recovery test of backup in a new server environment, and an error of "ORA-01861: literal does not match format string" occurs when a data file is restored. This error is not caused by incorrect setting of the