1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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..........

Question Posted / sureshbhandare


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

what is the use of home directory???

1 Answers   HP,

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

What is a correlated sub-query? : sql server DBA

0 Answers  




Which autogrowth database setting is good? : sql server DBA

0 Answers  

wat is global index and local indes

1 Answers   Oracle,

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

how can you initialize log miner?

0 Answers   Oracle,

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories