Oracle simple application

User Create: CREATE User Identified by

Default TableSpace Uses

Temporary TableSpace Temp;

New User Permission Settings: Grant Connect, Resource, Unlimited TableSpace To

User Discard: Drop User Cascade;

Cancel permission: Revoke From

Query users: SELECT * FROM DBA_USERS;

The query has been created: SELECT Username from dba_users;

Space: SELECT * from DBA_TABLESPACES;

Data Import: IMP / File = File Name .dmp Full = Y

Data Export: Exp / File = File Name .dmp Full = Y

Submitted: commit;

Add Database File: ALTER TABLESPACE USERS ADD DataFile 'Path /Users2.ora' Size 500M;

ALTER TABLESPACE RBS Add DataFile 'path / RBS2.ORA' SIZE 200M;

ALTER TABLESPACE TEMP Add DataFile 'Path / TMP2.ORA' SIZE 200M;

Open Table: ALTER ROLLBACK Segment RB * Online;

Close Table: ALTER ROLLBACK Segment RB * Offline;

Add a rollback segment: Alter Rollback Segment RB * Storage (Next 2M Optimal 10m);

Create a rollback segment: Create Public Rollback Segment RB * Storage (Next 2M Optimal 10m);

Registration Language: zhs16gbk or zhs16cgb231280

Start listener: lsnrctl status (see state)

LSNRCTL START (start)