Backing Up and Restoring Objects
With SQL Server, it is typical to restore a database to get a copy of just the objects that are needed. With Oracle, restoring the database is normally to restore the full system, but there are utilities available to pull out just the objects by schema, or even at the table level. This allows you to secure backups for these objects or copy them to another system, perhaps to refresh a test environment with just the needed schema or tables.
Copying Objects at the Table and Schema Level
Using a SQL statement, you can create a table from an existing table for a quick backup of a table before data changes. A backup table can be defined (such as CREATE table TAB_BACKUP AS select * from TAB_PROD) with tablespaces, no ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
