Basic Command Management and Operation of oracle Database

Basic Command Management and Operation of oracle Database

Start the database

View tablespace

View data files

Create a data file called t373 with a size of 10m and set it to grow automatically

Resize the data file

View data file resize successfully

Set the data file to read-only

Add a data file

Release the read-only state again and make it readable and writable

Add a data file with a size of 80m

Added successfully

Create a mapengfei user with a password of 123456. By default, the tablespace of t373 is used and the limit is 50m. The password is invalidated and reset when you log in for the first time.

At the initial stage of creation, there is no corresponding permission to log in to the database.

Mapengfei user is granted the right to connect to the database, and the login is successful.

Create a data file named benet. Size is 200m

Resize the data file

It became 400m.

Add a data file again

There are two data files

Create a user, using the default tablespace, with a limit of 50m

Create a table named t373

Authorization

Authorized to Benet users to view Scott's emp table

Verify that authorization is successful

Insert data into the t373 table

Authorized user Benet can modify the emp table of Scott

Modified successfully