My most common Oracle commands

 

• Create user
  Create user... identified by PWD;
• Delete a user
  Drop user... cascade;
• Create a tablespace
  Create tablespace ts_drp datafile 'd: \ drp-date.dbf 'size 2000 m
• Allocate tablespace to users
  Alter user... default tablespace ts_drp;
• Authorization
  Grant DBA (resource, connect) to user
• Revoke permissions
  Revoke DBA (resource, connect) from user
• Modify Table space name
  Alter tablespace ts_surao Rename to headgmp;
• Import File
  IMP head/head @ orcl file = F: \ new. dmp fromuser = newmmsroot touser = head ignore = Yes
• Note:When importing files, it is best to confirm that the name of the backup tablespace is the same as that of the new tablespace. Otherwise, many errors will be reported.

Create user head identified by head;

Create tablespace headgmp datafile '/u01/oradata/head/head-date.dbf' size 200 m autoextend on extent management local

Segment space management auto;

Alter user head default tablespace headgmp;

Grant connect to head;

IMP head/head @ Wilson file =/u01/expdat. dmp full = y ignore = Yes