Solved

Oracle Create backup table

Posted on 2014-09-08
3
459 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 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

733 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