I want to copy rows from one TableA, with over a million records, to anther TableB with identical column names, both in the same Schema. TableB is completely emply, but has several more columns, so in effect, TableA is a subset of TableB. How do I copy rows from Table A to the empty, Table B? Thanks.
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.