Create tablespace 1 2 3 4 5 >droptablespaceTABLESPACEincludingcontentsanddatafiles;>createtablespaceTABLESPACEdatafile'TABLESPACE.dbf'size500Mautoextendonnext5Mmaxsizeunlimited;>dropuserUSERcascade;>createuserUSERidentifiedbyPASSWORDdefaulttablespaceTABLESPACE;>grantconnect,resourcetoUSER; Create user 1 2 3 4 >connsystem/123456assysdba>altersessionset"_ORACLE_SCRIPT"=true;>createuserguestidentifiedby123456;>grantconnect,resource,dba,selectanytabletoguest; Common commands 1 2 3 4 5 6 7 >SELECTtable_nameFROMuser_tables;>SHOWTABLES;>SHOWVIEWS;>describeTABLE-NAME;>select*fromnls_instance_parameters;>select*fromnls_instance_parameters;>select*fromnls_session_parameters; Check encode 1 >selectuserenv(‘language’)fromdual; 1 2 3 4