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

What does select top 1 do in sql?

1021

What is over () in sql?

901

What is dense_rank in sql?

925

Explain what is sql*plus?

1095

what is bcp? When is it used?

1058

What is the most important ddl statements in sql are?

956

What is meaning of <> in sql?

1025

Why we use stored procedure instead of query?

958

In pl/sql, what is bulk binding, and when/how would it help performance?

950

What is write ahead logging in sql server?

998

How do I tune a sql query?

942

What is a dirty read sql?

1050

Why is partition used in sql?

1059

What are all ddl commands?

1023

How to Declare Fixed Length String Value In PL SQL

1113