Oracle

I. ORACLE internal structure1. Table SpaceA tablespace is a logical division of a database, a table space belongs to only one database, each table space consists of one or more data files, and other logical structures in the table space are stored

CREATE TABLE Space--View all users, and the corresponding permanent table space, temporary tablespaceSelect Username,default_tablespace,temporary_tablespace from Dba_userswhere username= ' SYSTEM ';1.1 Creating a temporary table spaceCREATE

1.oracle View OperationsCreating view: Create view name as query data;Delete view: Drop view name;Cases:CREATE VIEW MyView as SELECT * fromTest_person;(You can modify the view, the modified data will affect the base table)CREATE VIEW MyView as

[Email protected] ~]$ Ps-ef|grep SmonOracle 14809 1 0 Sep25? 00:13:02 ORA_SMON_MAILP3[Email protected] ~]$ export ORACLE_SID=MAILP3[Email protected] ~]$ echo $ORACLE _sidMailp3[Email protected] ~]$ Sqlplus/as sysdba;Sql*plus:release 11.2.0.3.0

Is archiving mode really that important?For Oracle database, must be set to the archive mode, especially the production library, only in order to achieve a valid database full recovery, for security, remember.It is dangerous for some databases to be

--Execution in---sqlplus (awr time period)@?/Rdbms/Admin/Awrrpt.sql-----Generate snapshots manuallyexecDbms_workload_repository.create_snapshot ();--statement Three executions, grouped into snapshots--Querying SnapshotsSelect *

1. First we can log in to Oracle as SYSDBA as a Scott user.Conn Scott/ as Sysdba 2. Then I'll be able to create the user.Create User by 123; 3. Create a good user we can then modify the user's password.Alter User by Chen; 4. By default, the

First download and install Cx_oracle:: Installation: pip3.6 Install E:\PYTHON36\SCRIPTS\CX_ORACLE-6.0.2-CP36-CP36M-WIN_AMD64.WHL write a simple test code:Import cx_oracle as ora# print (ora.version) # Open database connection # conn = ora.connect

Recently contacted Oracle again for work reasons, so re-acquainted with Oracle's basic commands.--Change Password1. Run-type "cmd" carriage return2. Type "Sqlplus/nolog" carriage return3. Type "Conn/as sysdba" carriage return4. Type "ALTER user

I. Smon: System monitoring Process1. Mainly submitted data but has not yet been written to the data file to power down, restart the time, the Smon will be restoredA. Roll forward, the redo log file has been written but no data has been written to

First, the businessReview What is a transaction?An indivisible sub-operation forms a whole, which either executes successfully or fails all. Example: TransferReview Why do you use transactions? If you do not have a transaction, for example, a user

Basic syntax for user authorization: Grant permissions/role to username; Master2. Switch usersSwitch User basic syntax: Connect user name/password; Master3, xiaoming Change passwordChange Password basic syntax: password user name;Admin Change

Resources:Http://www.cnblogs.com/jiguixin/archive/2011/09/09/2172672.htmlhttp://blog.csdn.net/lanchengxiaoxiao/article/details/39251947Install package Download:Link: https://pan.baidu.com/s/1qYBeXT6 Password: FaagFirst, unzip the file, run Setup.exe,

/*oracle user Lock, database lock sometimes compared to eat resources, if a large number of resources consumed, then other applications will not have the resources to use, it will be abnormally closed or unable to open. When Oracle has a lock

Export can be understood as setting environment variables in the Linux bash. Can be used by the current shell and child shell.The meanings of these variables are somewhat meaningful and you can view the corresponding documents, and I'll explain to

Enter the machine and set the environment variables, such as:Export oracle_home=/main/app/oracle/product/11.2. 0/db_1export oracle_sid=devdbThen switch Oracle user, admin mode login Sqlplussu - oracle[[email protected]~]$ sqlplus/nologsql>

1. To enable Python to operate the Oracle database, first install the Cx_oracle package.2. Create a simple Python file to test whether the installation was successful.1 #!/usr/bin/env Python32 #-*-coding:utf-8-*-3 4 Importcx_oracle5DNS_TNS=CX_ORACLE.

When Oracle performs some DML operations, it has the flag of the active transaction on the Oracle block, if a transaction commits, because some blocks have been written back to DataFile before commit, or if the transaction affects too many blocks,

1. Login: sqlplus/@orcl as Sysdba2. Snapshot: Exec dbms_workload_repository.create_snapshot3.AWR report: @ $ORACLE _home/rdbms/admin/awrrpt.sqlIf you don't set Oracle_home, you'll find the exact

1. Export the database instance:operate under the cmd command:Exp database user name/password @ server ip:1521/ Example file=c:\devdb.dmp full=y2. Import the database instance:Create the related database, set up the related table space + user +