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 stored procedure is faster than query?

509

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

556

What is sql query optimization?

533

Are views faster than queries?

528

What are pl sql procedures?

506

What is a pl/sql block?

580

what are the performance and scalability characteristics of mysql? : Sql dba

517

What do you mean by rowid?

528

Is truncate ddl or dml?

530

Is drop table faster than truncate?

543

What happens when a trigger is associated to a view?

492

What is rank () in sql?

517

Which type of cursor is used to execute the dml statement?

518

What does the argument [or replace] do?

564

What operating systems are supported by oracle sql developer?

507