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 key?

523

What are the advantages of pl sql over sql?

548

How do I get sql certification?

528

What are the advantages of sql?

560

How to use sql statements in pl/sql?

580

What is sqlite used for?

531

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

621

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

533

What is an implicit commit?

559

How are functions and procedures called in PL/SQL?

593

What is the example of procedure?

525

What are the string functions in sql?

530

What does dml mean?

545

Why we use sql profiler?

562

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

532