Basic command management and operation of Oracle database

Basic command management and operation of Oracle database

Start the database

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/97/53/wKioL1ktT9jRlsYbAAVEvLNNTas771.jpg "style=" float : none; "title=" 1.jpg "alt=" Wkiol1ktt9jrlsybaavevlnntas771.jpg "/>

View Table Spaces

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M00/97/52/wKiom1ktT9vAh3UHAAZ9kNMjVIg471.jpg "style=" float : none; "title=" 2.jpg "alt=" Wkiom1ktt9vah3uhaaz9knmjvig471.jpg "/>

View data files

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M00/97/53/wKioL1ktT92QJJ-uAAUs9Fplx08068.jpg "style=" float : none; "title=" 3.jpg "alt=" Wkiol1ktt92qjj-uaaus9fplx08068.jpg "/>

Create a data file named t373 with a size of 10M, set to autogrow

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M02/97/53/wKioL1ktT96TmGpOAAOCkBsUYOc934.jpg "style=" float : none; "title=" 4.jpg "alt=" Wkiol1ktt96tmgpoaaockbsuyoc934.jpg "/>

Resetting the size of the data file

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M00/97/52/wKiom1ktT-DzPrqXAAKr0PRa_tM770.jpg "style=" float : none; "title=" 5.jpg "alt=" Wkiom1ktt-dzprqxaakr0pra_tm770.jpg "/>

View data file Reset size succeeded

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M00/97/53/wKioL1ktT-CTCcLBAAFGTDBzD84639.jpg "style=" float : none; "title=" 6.jpg "alt=" Wkiol1ktt-ctcclbaafgtdbzd84639.jpg "/>

Set data file to read-only
650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M01/97/52/wKiom1ktT-HDUZfBAAGkOBLNu90642.jpg "style=" float : none; "title=" 7.jpg "alt=" Wkiom1ktt-hduzfbaagkoblnu90642.jpg "/>

Add a copy of the data file

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M01/97/53/wKioL1ktT-PR4VmvAAUz2F5HlH8063.jpg "style=" float : none; "title=" 8.jpg "alt=" Wkiol1ktt-pr4vmvaauz2f5hlh8063.jpg "/>

Read-only state again, set to read/write

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M02/97/52/wKiom1ktT-PgJh2_AAIrGGLNpbU044.jpg "style=" float : none; "title=" 9.jpg "alt=" Wkiom1ktt-pgjh2_aairgglnpbu044.jpg "/>

Add a data file with a size of 80M

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M02/97/53/wKioL1ktT-SBiYCkAAMikNFqHe8444.jpg "style=" float : none; "title=" 10.jpg "alt=" Wkiol1ktt-sbiyckaamiknfqhe8444.jpg "/>

Add success

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M01/97/52/wKiom1ktT-XQIMiOAAGAOE3D1Do662.jpg "style=" float : none; "title=" 11.jpg "alt=" Wkiom1ktt-xqimioaagaoe3d1do662.jpg "/>

Create a Mapengfei user, password 123456, default to use t373 tablespace, limit 50M, password failed to reset on first login

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M01/97/53/wKioL1ktT-bBz5G3AANSuJij458297.jpg "style=" float : none; "title=" 12.jpg "alt=" Wkiol1ktt-bbz5g3aansujij458297.jpg "/>

Create initial 650) this.width=650 with no corresponding permission to log in the database; "Src=" https://s3.51cto.com/wyfs02/M00/97/52/ Wkiom1ktt-mzibzjaaagqi9bqzm645.jpg "style=" Float:none; "title=" 13.jpg "alt=" wkiom1ktt-mzibzjaaagqi9bqzm645.jpg "/ >

Grant Mapengfei user the ability to connect to the database and log on successfully

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M02/97/52/wKiom1ktT-rA4rXbAAGpeEnVaPA352.jpg "style=" float : Left; "title=" 14.jpg "alt=" Wkiom1ktt-ra4rxbaagpeenvapa352.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/97/52/wKiom1ktT_OSOlIHAAORCFA2StQ360.jpg "style=" float : none; "title=" 15.jpg "alt=" Wkiom1ktt_osolihaaorcfa2stq360.jpg "/>

Create a data file with the name Benet. Size is 200M

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M00/97/53/wKioL1ktT_TiAXVSAANDaOijnP4966.jpg "style=" float : Left; "title=" 16.jpg "alt=" Wkiol1ktt_tiaxvsaandaoijnp4966.jpg "/>

Resetting the size of the data file

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M00/97/53/wKioL1ktT_WSWscIAAKEIBSpJoQ164.jpg "style=" float : none; "title=" 17.jpg "alt=" Wkiol1ktt_wswsciaakeibspjoq164.jpg "/>

into a 400M

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M01/97/52/wKiom1ktT_bAznyYAAEBuL2_WI0116.jpg "style=" float : none; "title=" 18.jpg "alt=" Wkiom1ktt_baznyyaaebul2_wi0116.jpg "/>

Add a data file once again

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M01/97/52/wKiom1ktT_iTguzmAAMweBODkjM381.jpg "style=" float : none; "title=" 19.jpg "alt=" Wkiom1ktt_itguzmaamwebodkjm381.jpg "/>

There are two data files

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M01/97/53/wKioL1ktT_iyEXsTAAF5zEgK2Bs136.jpg "style=" float : none; "title=" 20.jpg "alt=" Wkiol1ktt_iyexstaaf5zegk2bs136.jpg "/>

Create user, use default tablespace, limit to 50M

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M01/97/53/wKioL1ktT_my8aubAAK_gCAXx4o714.jpg "style=" float : none; "title=" 21.jpg "alt=" Wkiol1ktt_my8aubaak_gcaxx4o714.jpg "/>

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M02/97/52/wKiom1ktT_uw3gtbAALsIOCKp2M406.jpg "style=" float : none; "title=" 22.jpg "alt=" Wkiom1ktt_uw3gtbaalsiockp2m406.jpg "/>

To create a table named t373

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M02/97/53/wKioL1ktT_uhk5c2AAKYGD02o9s154.jpg "style=" float : none; "title=" 23.jpg "alt=" Wkiol1ktt_uhk5c2aakygd02o9s154.jpg "/>

Authorized

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M02/97/52/wKiom1ktT_zwXQSeAAFnSLAQgBk329.jpg "style=" float : none; "title=" 24.jpg "alt=" Wkiom1ktt_zwxqseaafnslaqgbk329.jpg "/>

Authorized to Benet users to view Scott's EMP table

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/97/52/wKiom1ktT_zQ52atAAGidClj1x8195.jpg "style=" float : none; "title=" 25.jpg "alt=" Wkiom1ktt_zq52ataagidclj1x8195.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/97/53/wKioL1ktT_3TNLZ7AAJUMMhpCy0429.jpg "style=" float : none; "title=" 26.jpg "alt=" Wkiol1ktt_3tnlz7aajummhpcy0429.jpg "/>

Verify authorization Succeeded

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M02/97/53/wKioL1ktT_6TNXPmAAPpOOfD5xI833.jpg "style=" float : none; "title=" 27.jpg "alt=" Wkiol1ktt_6tnxpmaappoofd5xi833.jpg "/>

Inserting data into the t373 table

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M01/97/52/wKiom1ktUADyODKYAAVXaGA5GiA477.jpg "style=" float : none; "title=" 28.jpg "alt=" Wkiom1ktuadyodkyaavxaga5gia477.jpg "/>

Authorized user Benet can modify Scott's EMP table

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M01/97/53/wKioL1ktUAGzKiExAAGkBCEJ4zc505.jpg "style=" float : none; "title=" 29.jpg "alt=" Wkiol1ktuagzkiexaagkbcej4zc505.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/97/52/wKiom1ktUAGT8oIOAAIfmMc3vVA778.jpg "style=" float : none; "title=" 30.jpg "alt=" Wkiom1ktuagt8oioaaifmmc3vva778.jpg "/>

Modification succeeded

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M00/97/53/wKioL1ktUALxIlgcAAGLTCNRfVg646.jpg "style=" float : none; "title=" 31.jpg "alt=" Wkiol1ktualxilgcaagltcnrfvg646.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M02/97/52/wKiom1ktUAKBI2PEAAHh3Hy7pKE182.jpg "style=" float : none; "title=" 32.jpg "alt=" Wkiom1ktuakbi2peaahh3hy7pke182.jpg "/>

This article is from "Love Linux" blog, reproduced please contact the author!

Basic command management and operation of Oracle database