Learn Database Concepts

SQL> select PROTECTION_MODE,PROTECTION_LEVEL FROM V$DATABASE; PROTECTION_MODE      PROTECTION_LEVEL -------------------- -------------------- MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE SQL> select name,db_unique_name,open_mode,DATABASE_ROLE from v$database; NAME    DB_UNIQUE_NAME   OPEN_MODE        DATABASE_ROLE --------- ------------------------------ -------------------- ---------------- ORCL    ORCLSTB1   MOUNTED         PHYSICAL STANDBY   SQL> alter database open read only; Database altered. SQL> select name,db_unique_name,open_mode,DATABASE_ROLE from v$database; NAME    DB_UNIQUE_NAME   OPEN_MODE        DATABASE_ROLE --------- ------------------------------ -------------------- ---------------- ORCL    ORCLSTB1   READ ONLY        PHYSICAL STANDBY SQL> select PROTECTION_MODE,PROTECTION_LEVE...

********************************************************************** You can use this simple plsql block to drop all objects in your current schema. ********************************************************************** declare VSQL varchar2(4000); OBJ_NAME varchar2(100); OBJ_TYPE varchar2(100); OBJ_OWNER varchar2(100); cursor c1 is select object_type,object_name from user_objects where object_type in ('TABLE','VIEW'); begin open c1; loop fetch c1 into OBJ_TYPE,OBJ_NAME; exit when c1%NOTFOUND; IF OBJ_TYPE='TABLE'  THEN VSQL:=' drop '||OBJ_TYPE||' '||OBJ_NAME||' cascade constraints'; DBMS_OUTPUT.PUT_LINE(VSQL); execute IMMEDIATE VSQL; ELSE   VSQL:=' drop '||OBJ_TYPE||' '||OBJ_NAME; DBMS_OUTPUT.PUT_LINE(VSQL); execute IMMEDIATE VSQL; END IF; end loop; close c1; end; / Note : Remove "where object_type in ('TABLE','VIEW')" to drop all objects from current user. Or you can edit to include only type o...

********************************************************************** You can use this simple pl-sql block to drop all objects in your current schema. ********************************************************************** declare VSQL varchar2(4000); OBJ_NAME varchar2(100); OBJ_TYPE varchar2(100); OBJ_OWNER varchar2(100); cursor c1 is select object_type,object_name from user_objects where object_type in ('TABLE','VIEW'); begin open c1; loop fetch c1 into OBJ_TYPE,OBJ_NAME; exit when c1%NOTFOUND; IF OBJ_TYPE='TABLE'  THEN VSQL:=' drop '||OBJ_TYPE||' '||OBJ_NAME||' cascade constraints'; DBMS_OUTPUT.PUT_LINE(VSQL); execute IMMEDIATE VSQL; ELSE   VSQL:=' drop '||OBJ_TYPE||' '||OBJ_NAME; DBMS_OUTPUT.PUT_LINE(VSQL); execute IMMEDIATE VSQL; END IF; end loop; close c1; end; / Note : Remove "where object_type in ('TABLE','VIEW')" to drop all objects from current user. Or you can edit to include only type ...

**************************************************************                       FROM MY CLIENT MACHINE: ************************************************************** C:\Windows\System32>tnsping pdborcl1 TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-MAR-2016 15:32:20 Copyright (c) 1997, 2010, Oracle.  All rights reserved. Used parameter files: C:\app\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.215.XX4.XX)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = pdbo cl1))) OK (0 msec) ************************************************************** NOW I want my DB to be only be accessible from this machine and restrict all other. For this I will need to make changed to my DB server sqlnet.ora : ************************************************************** ON...