lcry

1. First check whether the current database is in the archive mode 1) select name, log_mode from v $database; The value of log_mode is NOARCHIVELOG, indicating that the database is in non archive mode. The value of log_mode is ARCHIVELOG, indicating that the database is in archive mode. 2) archive log list; (This method requires as sysdba) The value of Database log mode is No Archive

-Read the full text-

For the sake of data security, there are some restrictions on the IP address of the Oracle database. Only a fixed IP address can access it.

-Read the full text-

To enable oracle to directly call tables and views in sql server, oracle 11g transparent gateway can implement this function.

-Read the full text-

1、 Create a directory 1. Create a logical directory: (The directory must exist, or an error will be reported. Finally, create the directory dpdata as'/u01/app/oracle/oracledata/dump 'in system); Or create or replace directory dpdata as'/u01/app/oracle/oracledata/dump '; 2. View the manager directory select * from

-Read the full text-

--create table test as select * from T1 where 1=2; -- Copy table structure without copying data -- select * from test-- create table test2 as select * from T1;-- Copy the entire table to test2 -- select * from test2-- insert into test select * from T1;-- take

-Read the full text-

Solution: select * from v $session where username is not null; alter system kill session '29,49'; drop user test cascade;

-Read the full text-

1、 Demo system version: cat/etc/redhat releaseCentOS release 6.10 (Final) II. Preparation before installation: 1. Download oracle11glinux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zip Upload to the server through xftp to update the oracle dependency package. Execute the command on the terminal first: yum - y install binu

-Read the full text-

Environment: Centos Oracle 10.2.0.0 User involved: root oracleA Delete oracle software and instance Steps: 1. Oracle user logs in sqlplus Stop database: shutdown immediate 2. Oracle user stops listening service: lsnrctl stop3. Root user deletes/tmp Oracle * file delete/opt Oracle * file delete/etc OraInst.loc and Oratab files (these two files

-Read the full text-

If Oracle does not know the system, the password of the sys user can be retrieved by the following methods:

-Read the full text-