Solved

Oracle Create backup table

Posted on 2014-09-08
3
456 Views
Last Modified: 2014-09-08
I have a table named TableA.  How do I copy it to a backup named TableA_Bak?

Thanks,
0
Comment
Question by:Dovberman
3 Comments
 
LVL 48

Assisted Solution

by:PortletPaul
PortletPaul earned 200 total points
ID: 40311325
CREATE TABLE TableA_Bak
  AS (SELECT * FROM TableA);
0
 
LVL 6

Accepted Solution

by:
Mandeep Singh earned 300 total points
ID: 40311339
try this:
create table TableA_Bak as select * from TableA;

Open in new window


also if you want only structure:
create table TableA_Bak as select * from TableA where 1=0;

Open in new window

0
 

Author Closing Comment

by:Dovberman
ID: 40311371
Thank you.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can anyone please tell me what does below Stored Procedure does? 4 33
migration MS SQL database to Oracle 30 69
Creation date for a PDB 5 39
Oracle Insert not working 10 32
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
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 * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question