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 |
Do we need commit after truncate?
How can you fetch common records from two tables?
How do you display "13th of November, 17 days left for month end" without hardcoding the date.
Why do we use joins in sql?
What are the possible values for the boolean data field?
In pl/sql, what is bulk binding, and when/how would it help performance?
What are inner outer left and right joins in sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
what is the difference between delete and truncate commands? : Sql dba
Does oracle roll back the transaction on an error?
what is 'force view'?
How to run sql*plus commands in sql developer?