- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Export
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-13-2003 07:02 AM
тАО05-13-2003 07:02 AM
10x
RPM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-13-2003 07:37 AM
тАО05-13-2003 07:37 AM
SolutionTo restore you could import the schema export file and then import the others with "ignore=y" to ignore the fact that the tables already exist.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-13-2003 06:23 PM
тАО05-13-2003 06:23 PM
Re: Oracle Export
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-13-2003 09:58 PM
тАО05-13-2003 09:58 PM
Re: Oracle Export
in general large exports rules are:
use the filesize parameter
export smaller pieces (using tables= or owner=)
export to a device that does not support seeking
Hopefully, this does not form part of you main backup strategy!
Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2003 02:00 AM
тАО05-14-2003 02:00 AM
Re: Oracle Export
Our settings for export are:
# For conventional path exports:
Direct = N
Buffer = 10485760
# For direct path exports:
Direct = Y
Recordlength = 65535
Direct export is VERY fast. If you don't use it now, you could try it. For ins and outs, check the manual.
For import, set your buffer large:
Buffer = 10485760
There is no 'direct' import.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2003 05:54 AM
тАО05-15-2003 05:54 AM
Re: Oracle Export
just a couple of notes.
You can use direct=y only if you have no chaset conversion.
If you will import the data on another db or if you have set some env variables, like NLS_LANG, you can have some surprises.
Another important issue is the import: if you use parallel import (many imp) you will have to pay attentio to temp tablespace (for creating indexes) and to rollback segments.
If you dare, you can also try in import commit=y, that can improve performance.
With this parameter, you will have a commit at the end of the table, not after each row.
DRAWBACK: you must have a rollback segment large enough to store the ENTIRE TABLE. And this might be space consumig...
HTH
Massimo