I want to export only structure of the table from oracle
database. In that table to used the some partition.
To export the table in general way then compilation error
was occured i.e-EXP-00003: no storage definition found for
segment(11, 2771). Please tell me the correct export command
parameter to export the partitioned table.

Thanks in Advance..........



I want to export only structure of the table from oracle database. In that table to used the some p..

Answer / mohammed

Please go through the following URL:
http://www.oracle-dba-online.com/export_and_import.htm

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB Administration Interview Questions

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  


How would you begin to troubleshoot an ORA-3113 error?

1 Answers  


Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  


What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  


what is ora 24313?what is the procedure to exclude that error?

0 Answers  


Explain CREATE DATABASE syntax?

2 Answers  


what is the difference between db2start command and start database manager command?

1 Answers  


What is the default fill factor value? : sql server DBA

0 Answers  


You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  


what r the types of backup?

5 Answers   CSC,


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  


What is fill factor? : sql server DBA

0 Answers  


Categories