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

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers

what is the use of recording information about current session?

0 Answers Oracle,

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

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

What background process refreshes materialized views?

2 Answers Accenture, FLSmidth,

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers

what is logical system in sap basis

0 Answers

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers

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

0 Answers

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here