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 are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1034

What packages(if any) has oracle provided for use by developers?

5797

Is a secondary key the same as a foreign key?

1027

How many columns should be in an index?

959

What are the types of join and explain each?

1029

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

958

what is the difference between inner and outer join? Explain with example. : Sql dba

1018

Can you rollback after commit?

974

What are the types of keys?

988

Can we commit in trigger?

960

Should I use mbr or gpt?

1022

How is pl sql different from sql?

1077

Which are the different character-manipulation functions in sql?

1055

What is cascade in sql?

954

What is Collation Sensitivity ? What are the various type ?

944