- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- How to import just data without trying to rebuild ...
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
тАО09-19-2003 06:10 AM
тАО09-19-2003 06:10 AM
How to import just data without trying to rebuild the tables?
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace AAMDATA
Import terminated successfully with warnings.
I am using ignore=y, which I thought would continue loading data after the failed create, but the table is still empty.
Can imp be run so that it doesn't try to create the table, or that it really ignores the error and just finishes the data load?
Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2003 06:35 AM
тАО09-19-2003 06:35 AM
Re: How to import just data without trying to rebuild the tables?
my first idea would be:
create a database link in test instance to production instance.
create table in test as select from production table.
Would that be sufficient?
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2003 06:52 AM
тАО09-19-2003 06:52 AM
Re: How to import just data without trying to rebuild the tables?
here??s my second thought. Are you sure, you have enough space? Also check the compress parameter. If it is set to yes, imp will try to allocate enough for the first extent to fit all data into it. ignore=y otherwise should work.
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-21-2003 12:42 PM
тАО09-21-2003 12:42 PM
Re: How to import just data without trying to rebuild the tables?
You can import the data without the table creation by giving the ignore=Y option in the import parameters.
With the erro you are getting ORA-01658, indicates that the initial extent size of the table into which you are importing is not big enough to hold the data. The reasons could be....
1. If while exporting you had given compress=y then the import utility will try to place the entire data into one extent which will be the initial extent.
2. If you are sure that you did not give compress=Y and as you said the two table storage parameters are different, and may be the table in the test environment has smaller extent sizes. If there is enough space in the test environment then the best way would be to recreate the table before or while importing with proper sizes.
When you drop the table and recreate you have to make sure to grant the previllages that existed if any.
I hope this helps.
IA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-21-2003 09:18 PM
тАО09-21-2003 09:18 PM
Re: How to import just data without trying to rebuild the tables?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-22-2003 03:14 AM
тАО09-22-2003 03:14 AM
Re: How to import just data without trying to rebuild the tables?
First - I assume you do have enough space in the test instance, it just might be fragmented. If you DON'T have the space, then this won't work.
Then - I precreate the table with no data using whatever storage parameters are appropriate for the test version. If I am really having problems with space I don't create the indexes either.
I then do the import with ignore=Y, and again if space is a real problem I also have indexes=N
It won't matter how the export was done, the storage clause of the existing table will be used. After the table is imported, the indexes can be created in a different tablespace - move the primary key index first.
Hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-22-2003 01:24 PM
тАО09-22-2003 01:24 PM
Re: How to import just data without trying to rebuild the tables?
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-22-2003 04:36 PM
тАО09-22-2003 04:36 PM
Re: How to import just data without trying to rebuild the tables?
The error you are getting means the tablespace AAMDATA you have setup does not enough of contigous free space in it.
You should ensure that the schema owner where you have created the table is the same you are using for the import are the SAME! It seems like the IMP process is creating the table again!
or you can specify the following options when importing:
fromuser=
You can use the attached script for verifying the amount of free space available.
In sqlplus. It'll show use by tablespace & database the amount of space ALLOCATED, the amount USED and by tablespace the LARGEST CONTIGOUS FREE chunk of space (the max size of a next extent in that tablespace).
Also, when you export, make SURE you are not using compress=y (the default). It'll ballon up your tablespaces. The initial in the export is equal to the sum of all ALLOCATED extents for the existing table.
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-22-2003 04:39 PM
тАО09-22-2003 04:39 PM