Solved

Oracle Create backup table

Posted on 2014-09-08
3
463 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 49

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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

695 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