Oracle

Control Panel-> Add hardware, select "Yes, connected to this hardware" in the Wizard → add new hardware devices → install me manually list select hardware (advanced) → network adapter → vendor: Microsoft NIC: Microsoft loopback Adapter. After the

1. Execute sp_addmediaserver in the query Analyzer  Use master Go Exec sp_addmediaserver @ Server = 'ralph. lanstart', -- Name of the Oracle linked server @ Srvproduct = 'oracle ', -- fixed @ Provider = ''msdaora '', -- fixed @

Create or replace procedure proc_drop_table (t_name in varchar2) is c_type varchar2 (20); t_count int; v_count int; I _count int; s_count int; begin begin select object_type into c_type from all_objects where object_name = upper (t_name); Exception

First, set a user group for the normal installation of oracle; [Root @ localhost ~] # Groupadd oinstall[Root @ localhost ~] # Groupadd DBA A user account is called Oracle, and a group is called oinstall and DBA. [Root @ localhost ~] #

Recently, SAP archiving and Database Reorganization have just been completed. After the database reorganization, the temporary tablespace is reduced to make reasonable use of resources. The steps are as follows: 1. Create a new temporary tablespace

Summary of Oracle Database Development Optimization   Although the cost of hardware is already very low, the use of hardware performance can block problems caused by software performance issues to some extent, but this does not mean that the

Create or replace procedure ecs_customdetail_0929 -- create a stored procedureIsLongerstation varchar2 (50); -- defines VariablesType v_cursor is ref cursor; -- Variable-definition cursorDetailid v_cursor;In_id v_cursor;V_str varchar2 (200 );In_str

The Oracle Server maintains the redo Oracle log files to minimize the loss of data in the database in case of an uncontrolled shutdown. Online redo Oracle log files are filled with redo records. A redo record, also called a redo entry, is made up of

Oracle tips by Burleson Consulting Oracle SGA concepts The system global area (SGA) is a group of shared memory areas that are dedicated to an oracle instance? (An instance is your database programs and RAM ). All Oracle processes use the SGA to

Redo(Redo) In addition to the data files used to save data, each Oracle database has a set of (two or more) redo log files. Redo logs are used to save all changes to the data, including submitted and unsubmitted changes. Before writing changes to

In large databases, procedure is often called because of development needs. procedure is different in Oracle and sqlserver due to different syntaxes, but in debugging, is relatively difficult, especially in some error handling. First, debug: 1. For

I have made performance optimization over the past few days and found some information online. Sometimes you need to export all the table, view, sequence, trigger and other information of a user. The following SQL statement can select the

Oracle Database frequently used operation commands recently encountered a server that uses Oracle databases. After learning Oracle +, I finally got all the user passwords on the website background management interface, I found that Oracle operations

For and while loops in Oracle Conditional loops can be implemented in two ways. 1. For variable in start value... end value loop end loop; 2. While condition loop end loop; Loop usage: The exit when statement can appear anywhere in the loop code;

1: >=replace>2: Use less *3: Try not to use having4: Reduce table queries in statements containing subqueriesSelect tab_name from tables where (tab_name, db_ver) = (selectTab_name, db_ver from tab_columns where version = 604)5. Use Oracle functions

Oracle Database deletion under windwos: 1: run the universal installer command to uninstall oracle first. 2: Go to the Oracle installation directory and delete it like deleting a common file. You can't delete it. You can use 360 to delete the file

Author: skateTime: 2010/09/07 Resetlogs mechanism of Oracle   I think everyone is familiar with the alter database open resetlogs command. Have you ever wondered why this resetlogs option should be used? When will it be used?What is its mechanism?

1 Introduction The Oracle stream function is designed to improve the high availability of the database. In Oracle 9i and earlier versions, this function is called Advance replication. Oracle stream uses advanced Queue Technology to parse archived

 // If the current user is root, use the sysdba role to connect to the Oracle instance. # Su Oracle# Sqlplus/nolog# Conn/As sysdba   // Basic operation after connection SQL> select username from dba_users; // view all user namesSQL> select table_

Today, we need to collect statistics on the updates of the three website columns. The three websites use different database management systems at the backend. The initial idea is to create a small Tomcat webapp to access the three backend databases