- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Import large schema - oracle 10G
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
тАО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
- 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
- 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
- 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
- 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
- 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
- Report Inappropriate Content
тАО12-02-2008 11:47 AM
тАО12-02-2008 11:47 AM