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 write ahead logging in sql server?
what is the purpose of update command in oracle?
What is difference between left and right outer join?
what is purge command explain about oracle performance tuning
2 Answers Accenture, eCentric Solutions,
how to create a new table by selecting rows from another table in mysql? : Sql dba
When to use inner join and left join?
Explain 3 basic parts of a trigger.
How can we solve sql error: ora-00904: invalid identifier?
What is primary key in db?
Do we need to rebuild index after truncate?
Does mysql support pl sql?
What is a pl/sql block?