<div>
<div class="content wysiwyg-content">
I've just deleted a huge amount of data from several tables using the SQLPLUS TRUNCATE command. &nbsp;Unfortunately this doesn't have any affect on the size of the database backup. &nbsp;What options do I have for reducing the size of the database and backup files (easiest method first please)?
</div>
</div>


I've just deleted a huge amount of data from several tables using the SQLPLUS TRUNCATE command.  Unfortunately this doesn't have any affect on the size of the database backup.  What options do I have for reducing the size of the database and backup files (easiest method first please)?

Oracle 9i - return space after SQLPLUS  TRUNCATE

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.