Interested to Buy Any Domain ? << Click Here >> for more details...
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..........
- 1 Answers
- 12583 Views
- I also Faced
- E-Mail Answers
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
Why would you call update statistics? : 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?
. 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?
Query processing is slow(eg select query)how will u solve that
How would you go about verifying the network name that the local_listener is currently using?
what is the diffrence between core dba and apps dba?
What purpose does the model database server? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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.
What is fill factor? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
