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..........
Answer Posted / 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 View All 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
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what are the benefits of flashback feature?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What are the different ways you can create databases in sql server? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
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.
What is the difference between clustered and non-clustered index? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the commands used in dcl? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
which background process invoke at the time of upgradation tell me???
Can you redefine a table online?