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

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 the dataguard background process??

1 Answers iGate,

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

0 Answers

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers

Datapump backup steps?

1 Answers

what is the role of dip user in our database?

0 Answers

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers TCS,

For more DB Administration Interview Questions Click Here