Useful Technology Tips

1. How to add TNS listener for the Oracle (10g)
Configuration and Migration Tools --- > Net Configuration Assistant --> Listener configuration --> Add Listener

2. How to drop a database with sql*plus

SQL*Plus: Release 10.1.0.3.0 - Production on Fri Feb 18 20:15:26 2005

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                   790352 bytes
Variable Size             174321840 bytes
Database Buffers          436207616 bytes
Redo Buffers                1048576 bytes

SQL> alter database mount exclusive;

Database altered.

SQL> alter system enable restricted session;

System altered.

SQL> drop database;

Database dropped.

3. How to delete all the tables/views/indexes .. from a database without dropping it.

step1: Create a user and grant permission to the DB
step2: Remove the user then it will automatically remove all the tables and views etc...
(e.g. drop user username cascade;)