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
how can you find out if a table can be redefined?
what are the differences of where and if in SAS?
What are the different sql server versions you have worked on? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what do you understand by fine-grained auditing?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What is the default fill factor value? : sql server DBA
What is dcl? : sql server DBA
Why would you use sql agent? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is logical system in sap basis
what is asm?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
what functionality does oracle provide to secure sensitive information?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?