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

Answer / k.l.rajesh babu

BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'

Answer / suresh

BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'

Answer / vikneswaran

SELECT column_name(s)
INTO new_table_name
FROM old_tablename

Answer / rk

we can do it from user_tables

like

select table_name,tablespace_name from user_tables;

Answer / ganesh

create table backup as select * from user_tables;

create table backup1 as select * from user_source;

Answer / manojbatra071

create table backuptablename as select * from originaltablename;

what are rollup and cube in t-sql? : Transact sql

0 Answers  

Its possible to add more than one primary key for the table

4 Answers  

How do I run a sql query in pgadmin 4?

0 Answers  

How are functions and procedures called in PL/SQL?

0 Answers  

What is the use of a view in sql?

0 Answers  

How is a PL/SQL code compiled?

0 Answers  

How do I sort a table in sql?

0 Answers  

What is difference between cursor and ref cursor?

1 Answers  

How do I create an index in word?

0 Answers  

What is a sql profiler?

0 Answers  

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

How to read/write files from pl/sql?

0 Answers