I want to export only structure of the table from oracle database. In that tabl

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

1 Answers
12726 Views
I also Faced
E-Mail Answers

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 meant by gateway

1 Answers IBM,

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

4 Answers DELL, TCS,

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

0 Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers

How can we know the exact updation date of a particular database?

2 Answers Satyam,

what is the differnce between process and thread ?

1 Answers IBM,

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers

how does an oracle clusterware manage crs resources?

0 Answers Oracle,

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers CSC, Logica CMG,

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

For more DB Administration Interview Questions Click Here