SQL DELETE Statement

The DELETE statement is used to delete records in a table.

SQL DELETE Syntax

DELETE FROM table_name
WHERE column=value

Delete All Rows

DELETE FROM table_name
or
DELETE * FROM table_name

Be very careful when deleting records.

Datafile information from the control file.

Enter user-name: SYS as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT NAME
2 FROM V$DATAFILE;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORA11DEV/system01.dbf
/u01/app/oracle/oradata/ORA11DEV/sysaux01.dbf
/u01/app/oracle/oradata/ORA11DEV/undotbs01.dbf
/u01/app/oracle/oradata/ORA11DEV/users01.dbf
/u01/app/oracle/oradata/ORA11DEV/example01.dbf
/u01/app/oracle/oradata/ORA11DEV/examsql01.dbf

6 rows selected.

SQL> SELECT NAME, STATUS, BYTES, BLOCK_SIZE, BLOCKS
2 FROM V$DATAFILE;

V$DATAFILE_HEADER

SQL> SELECT NAME, TABLESPACE_NAME
2 FROM V$DATAFILE_HEADER;

Change password locked unlocked account

Inicie o SQL*Plus:
sqlplus /NOLOG
Connect como SYSDBA:
SQL> CONNECT / AS SYSDBA

ALTER USER username ACCOUNT UNLOCK;

ALTER USER username ACCOUNT LOCK;

ALTER USER username IDENTIFIED BY password;

ALTER USER username IDENTIFIED BY password ACCOUNT UNLOCK;