oracle - drop user (schema)

0. drop oracle schema

schema export/import를 위해 schema를 삭제하려면?

SQL> drop user schema_name cascade;

 ORA-01940: cannot drop a user that is currently connected 발생시?

SQL> select sid, serial#, username, status from v$session where schemaname='schema_name'

SQL> alter system kill session 'sid, serial#' immediate;

1. create user

SQL> create user schema_name identified by passwd;

        SQL> grant dba to schema_name;