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 |
Where would you look for errors from the database engine?
Can you redefine a table online?
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?
How would you determine what sessions are connected and what resources they are waiting for?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what are the types of connection load-balancing?
Explain the concept of the DUAL table.
how can you communicate with operating system files from oracle?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
When a user process fails, what background process cleans up after it?
why we use cursors
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)