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;

Does execute immediate commit?

0 Answers  

What is a clob in sql?

0 Answers  

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

How to display the current date in sql?

0 Answers  

What are character functions?

0 Answers  

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

What are different types of sql commands?

0 Answers  

Can we enter data in a table in design view?

0 Answers  

Can I create table without primary key?

0 Answers  

How to use distinct and count in sql query? Explain

0 Answers  

How do I remove all records from a table?

0 Answers  

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,