- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Ora 01650
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
тАО03-26-2004 10:49 PM
тАО03-26-2004 10:49 PM
Ora 01650
When i am importing data from export i get an error Ora-01650 unable to assign initial extent
Why is this thrown up and what is the best solution ?
Thanx in adv
Amit.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2004 11:23 PM
тАО03-26-2004 11:23 PM
Re: Ora 01650
it would be helpfull to know oracle version and patch level.
The error description at the bottom is from metalink and look a bit different than what you mentioned.
Can you check? Thanks,
Michael
ORA-01650: unable to extend rollback segment %s by %s in tablespace %s Cause: Failed to allocate extent for the rollback segment in tablespace. Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2004 11:42 PM
тАО03-26-2004 11:42 PM
Re: Ora 01650
Using the option commit=y in the import command:
imp user/passwd file=exp_filename log=logname full=y commit=y ignore=y
should resolve the problem
Good luck
Victor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2004 12:55 AM
тАО03-27-2004 12:55 AM
Re: Ora 01650
one more thing. When you import and you can tell imp to put the whole table into one extent. That might not work.
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2004 12:33 PM
тАО03-28-2004 12:33 PM
Re: Ora 01650
When you get the error "ORA-01650 unable to assign initial extent" while importing, that means the tablespace in which the table is being created does not have the number of contigues bytes to be allocated for the initial extent. Or if you exported with compress=Y then the import will try to put the complete data into one extent.
If you know the number of rows the table has and the size of the table then you can pre-create the table with the proper initial and next extents and then try to import the data with ignore=Y patameter.
Otherwise may be you require to increase (resize) the tablespace datafile or add a datafile to allocate more space to the tablespace.
Eg: alter tablespace add datafile 'path/datafile_name.dbf' size ?? M;
or
alter database datafile 'path/datafile_name.dbf' resize ?? M
Then try to import the table data.
I hope this helps
Indira A