- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - HP-UX
- >
- General
- >
- Re: Import large schema - oracle 10G
-
- Forums
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Blogs
-
Information
-
English
- 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
- Email to a Friend
- Report Inappropriate Content
12-01-2008 12:24 PM
12-01-2008 12:24 PM
OEM import job keeps failing due to lack of temp space which is set to 50 GB.
Appears to be failing at index creation step...
Does initial index creation use temp space???
How do we work around this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-01-2008 12:25 PM
12-01-2008 12:25 PM
Re: Import large schema - oracle 10G
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-01-2008 12:35 PM
12-01-2008 12:35 PM
Re: Import large schema - oracle 10G
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-01-2008 05:24 PM
12-01-2008 05:24 PM
SolutionIf it does still fail, maybe report some more pertinent details like the rowcount and indexed defintion.
But really... this is very likely to be a platform independent user issue for which an Oracle forum will be much more appropriate than an HPUX forum.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2455
1) Import using the INDEXFILE parameter to create a file of index-creation statements
2) Edit the file, making certain to add a valid password to the connect strings.
3) Rerun Import, specifying INDEXES=n.
(This step imports the database objects while preventing Import from using the index definitions stored in the export file.)
4) Execute the file of index-creation statements as a SQL script to create the index.
The INDEXFILE parameter can be used only with the FULL=y, FROMUSER, TOUSER, or TABLES parameters.
fwiw,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-01-2008 09:27 PM
12-01-2008 09:27 PM
Re: Import large schema - oracle 10G
as mentioned previously, you need to separate your index creation with your table creation.
Obviously, OEM will not help here.
How many objects (tables, indexes) are there?
Can you categorise tables into 3 groups: small, medium and large?
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-02-2008 02:54 AM
12-02-2008 02:54 AM
Re: Import large schema - oracle 10G
and indeed it is good practice to bulk load the tables first and then bulk create the indexes after wards. Usually saves time.
But just to answer your question.
Indeed initial index creation uses temp space, as this space is used to sort the index it gets a evenly spread Btree.
a good site to ask Oracle related questions:
www.dba-village.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-02-2008 11:47 AM
12-02-2008 11:47 AM
Re: Import large schema - oracle 10G
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2021 Hewlett Packard Enterprise Development LP