write the Sql query for creating database backup?
Answers were Sorted based on User's Feedback
Answer / gourvendra singh
if you need to take tha backup of the database on ur hard
disk then u can use the following query:
exp userid=system/manager@orcl file=location\abc.dmp full=y
log= abc
Is This Answer Correct ? | 23 Yes | 4 No |
Answer / k.l.rajesh babu
BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'
Is This Answer Correct ? | 16 Yes | 2 No |
Answer / suresh
BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / vikneswaran
SELECT column_name(s)
INTO new_table_name
FROM old_tablename
Is This Answer Correct ? | 3 Yes | 8 No |
Answer / rk
we can do it from user_tables
like
select table_name,tablespace_name from user_tables;
Is This Answer Correct ? | 5 Yes | 12 No |
Answer / ganesh
create table backup as select * from user_tables;
create table backup1 as select * from user_source;
Is This Answer Correct ? | 4 Yes | 13 No |
Answer / manojbatra071
create table backuptablename as select * from originaltablename;
Is This Answer Correct ? | 3 Yes | 13 No |
What is the difference between left and left outer join?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,
What are the types of join and explain each?
What is a recursive join sql?
How do I view a sql database?
What is a transaction?
State the difference between implict and explict cursor's?
Do stored procedures prevent sql injection?
what is 'force view'?
What is the difference between sql and isql*plus?
What is sql and also describe types of sql statements?