we can do it from user_tables like select table_name,tablespace

write the Sql query for creating database backup?

Question Posted / rk

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Why is sql important?

1169

What are the constraints available in sql?

1084

What is trigger and how to use it in sql?

1065

what are the different type of normalization? : Sql dba

1066

How does left join work in sql?

1037

Why stored procedure is faster than query?

1152

How do I create a sql database?

1053

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1300

What are the benefits of pl sql?

1176

How can we find duplicate records in a table?

989

What is record data type?

978

How many types of indexes are there in sql?

1039

What found sql?

994

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1039

what is a constraint? Tell me about its various levels. : Sql dba

1044