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 |
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the steps you will take, if you are tasked with securing an SQL Server?
From the database level, how can you tell under which time zone a database is operating?
How would you go about generating an EXPLAIN plan?
Which autogrowth database setting is good? : sql server DBA
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
Give two methods you could use to determine what DDL changes have been made.
What are the ways tablespaces can be managed and how do they differ?
What are the different types of indexes available in sql server? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
What is fill factor? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)