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 / 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 |
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How would you begin to troubleshoot an ORA-3113 error?
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What is the difference between clustered and non-clustered index? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
Explain CREATE DATABASE syntax?
what is the difference between db2start command and start database manager command?
What is the default fill factor value? : sql server DBA
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
what r the types of backup?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is fill factor? : sql server DBA