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

From the database level, how can you tell under which time zone a database is operating?

1 Answers  


Describe what redo logs are.

1 Answers  


How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  


Where in the Oracle directory tree structure are audit traces placed?

1 Answers  


Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  






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

1 Answers  


Name two files used for network connection to a database.

5 Answers  


What is the difference between LMT & DLT?

1 Answers   CTS,


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

2 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  


orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,


Categories