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 is sql engine in oracle?

994

How do I know if I have sql express or standard?

1035

What do you understand by pl/sql cursors?

1090

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1028

What is a constraint? Tell me about its various levels.

1164

Can we use commit inside a trigger?

1095

what is a primary key? : Sql dba

1038

Which data dictionary views have the information on the triggers that are available in the database?

1240

how to rename an existing column in a table? : Sql dba

1020

What is the difference between microsoft sql and mysql?

967

What is clustered index sql?

988

How do you respond to dementia behavior?

972

Is coalesce faster than isnull?

967

What is using in sql?

1098

How can we avoid duplicating records in a query?

984