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

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

what is the differnce between process and thread ?

1 Answers IBM,

why do we give pctfree and pctused in create table statement?

1 Answers CTS,

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

what is the use of home directory???

1 Answers HP,

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

Explain how you would restore a database using RMAN to Point in Time?

1 Answers

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

0 Answers

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

Which autogrowth database setting is good? : sql server DBA

0 Answers

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers

For more DB Administration Interview Questions Click Here