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

How do you update sql?

912

What are the different dcl commands in sql?

1064

what is not null constraint? : Sql dba

964

What is a mutating table and a constraining table?

1035

What is a unique constraint?

1011

Is sql injection illegal?

963

Can we delete column in sql?

1020

Explain what is sql?

1058

Can a key be both primary and foreign?

943

What is recursive join in sql?

946

How to check if a column is nullable before setting to nullable?

1055

What is difference sql and mysql?

939

How to create a menu in sqlplus or pl/sql?

1062

Do stored procedures prevent sql injection?

918

what is “go” in t-sql? : Transact sql

1039