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,

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

1 Answers  

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  




What are the recovery models for a database? : sql server DBA

0 Answers  

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

How to make a replica of existing oracle server to another server?

3 Answers  

one datafile is lost in standy side how can you recover that??

2 Answers  

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

How would you force a log switch?

4 Answers  

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

For more DB Administration Interview Questions Click Here
Categories