Oracle Commands

sqlplus  system/manager@172.25.11.252/dlporacle11

sqlplus  scott/tiger@172.25.11.252/dlporacle11

select count(1) from dba_users;

select * from V$INSTANCE

SHOW USER;

select * from all_users;"

ALTER USER SCOTT ACCOUNT UNLOCK;

select count(1) from user_objects where object_type = 'TABLE';
select count(1) from tabs;
select table_name, partitioned from user_tables;

select * from dict;
select TABLE_NAME from ALL_ALL_TABLES;

CREATE USER jkang IDENTIFIED BY mcafee123
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
PROFILE DEFAULT;

GRANT RESOURCE TO jkang;
GRANT CONNECT TO jkang;
ALTER USER jkang DEFAULT ROLE ALL;
GRANT UNLIMITED TABLESPACE TO jkang;

CREATE TABLE "DDM_1000"
(    "SSN"        VARCHAR2(11 BYTE),
     "FIRST_NAME" VARCHAR2(20 BYTE),
     "LAST_NAME"  VARCHAR2(20 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;