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

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

what is a user-defined lock?

0 Answers   Oracle,

What is the difference between the 2 operating modes of database mirroring? : 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  

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  




how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

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  

how can you record information about current session?

0 Answers   Oracle,

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  

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

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

0 Answers  

How can you rebuild an index?

6 Answers  

For more DB Administration Interview Questions Click Here
Categories