error:ora 1659 in import the dmp file
cgf, May 22, 2002 - 9:14 pm UTC
Tom
I used the following command for import the dmp file.
C:>imp develop/develop file=c:\backup.dmp full=y
but the computer tell me the following information:
error:ora 1659
please tell me the reason.
OK.
cgf
May 22, 2002 - 11:05 pm UTC
you don't have the error messages manual?
01659, 00000, "unable to allocate MINEXTENTS beyond %s in tablespace %s"
// *Cause: Failed to find sufficient contiguous space to allocate MINEXTENTS
// for the segment being created.
// *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
// tablespace or retry with smaller value for MINEXTENTS, NEXT or
// PCTINCREASE
is this stement correct.......
a reader, May 23, 2002 - 4:28 am UTC
Tom, I thought that 'The database will not
shutdown with a shutdown immediate until everyone logs out gracefully' was a shutdown normal and NOT immediate. I'm sure that immediate kill user sessions and then exits gracefully.
May 23, 2002 - 7:41 am UTC
what I meant is that everyone is logged out gracefully -- they are rolled back. they are not aborted. the shutdown immediate results in a "clean" shutdown.
It will kill AND WAIT for the session to be cleaned out before shutting down. That was my point.
A shutdown abort -- that just STOPS the transactions right there, right then. The database is shutdown in a "fuzzy" state -- requires instance recovery upon restart.
sorry for the confusion.
Who is using Temp
Andrew Allen, May 23, 2002 - 11:44 am UTC
Here is a query I use to see who is using temp, how much they are using, and the sql doing it.
- - - - - - - -
SELECT /*+ ORDERED */
u.tablespace,
s.sid || ',' || s.serial# as sid_ser,
s.username,
s.osuser,
(SUM(u.blocks)*TO_NUMBER(a.value))/1048576 as blk_mb,
x.sql_text,
s.module || ':' || s.action as "Module:Action"
FROM v$sort_usage u
,v$session S
,v$sql X
,v$parameter a
WHERE s.saddr = u.session_addr
AND s.sql_address = x.address
AND s.sql_hash_value = x.hash_value
AND a.name = 'db_block_size'
GROUP
BY u.tablespace
, s.sid
, s.serial#
, s.username
, s.osuser
, a.value
, x.sql_text
, s.module
, s.action
ORDER
BY u.tablespace
, s.sid
;
A Little Clarification
TAF, May 23, 2002 - 12:27 pm UTC
Tom,
You might mention to him to convert this temp tablespace to a tempfile instead of being dictionary managed. I had the same problem with a 5g temp tablespace. When it blew it "locked" the tablespace until a system bounce or alter tablespace command. This is an Oracle bug, so to speak. I made the temp tablespace a truly tempfile and even after blowing the tablespace, it was immediately available for reuse. No system bounce needed.
May 23, 2002 - 3:33 pm UTC
...
Now often this blows up my temporary tablespace which is of the type temporary
and is around 6 gb in size.
.....
I assume based on his description -- that it is using tempfiles.
A reader, September 07, 2004 - 9:19 am UTC
Tom,
Could you please tell what are the rules/prerequisites and justifications in-order to bounce a production instance?
September 07, 2004 - 9:53 am UTC
you'd have to ask "your site" really. only your site knows what their concepts of operations is, what is allowable, what is feasible, what is optimal.
For example -- asktom.oracle.com, it is a "production instance". Guess what, if I feel like bouncing it, I will.
www.oracle.com is a production instance. it is never allowable for it to be down. same with our email, hr, order entry, etc -- not without weeks of advance notice.
Then there are systems that fall in between the two.
A reader, September 07, 2004 - 10:03 am UTC
Tom,
Thank you for the reply. We are planning a O/S reboot sometime. Is it a good time to restart 8.1.7? Can I bounce the instance and go for the o/s reboot? Any issues to be looked at? Please clarify
Dave, September 07, 2004 - 11:17 am UTC
if you are bouncing the OS, then you have no choice but to bounce the instance
A reader, September 07, 2004 - 11:19 am UTC
Ok, Thank you. Any effects of o/s boot on oracle? Any things that should be done manually on oracle after o/s boot? Please suggest as I am new!
September 07, 2004 - 12:45 pm UTC
this is something the DBA would take care of?
A reader, September 07, 2004 - 1:13 pm UTC
Tom,
The dba is really busy with some other things and this needs to be done by me. Any pointers?
September 07, 2004 - 2:10 pm UTC
you are kidding right?
theoretically, if the DBA set up the machine properly, the database will take care of itself.
if they didn't set it up to autostart, you'll need the DBA as you need DBA privileges.
A reader, September 07, 2004 - 6:17 pm UTC
Tom,
Thank you for the answer. The action was performed and o/s (hp-ux 11.00) was shutdown & brought up and so the oracle. However, there were some application related issues ( still working on ...) Should oracle be shutdown manually/gracefully prior to o/s shutdown? i.e without relying on the o/s d/b shutdown functionality?
September 08, 2004 - 8:15 am UTC
it would have been "nice" but not necessary to cleanly shutdown the database yes. Normally, the DBA would have set it up so the machine would include oracle in its normal shutdown processing. So, if the DBA was doing what DBAs should do -- it did shutdown cleanly.
Esi, December 02, 2004 - 8:23 am UTC
i have a cgi web page.now i want it to throw an error where there is a null value.again i want to restrict the input of duplicate values for the mobile number.i have tried all i can but when i get one to work ,the other doesnt work.that is when i manage to check for null values ,it doesnt respond to the following command like moving to the next page but still brings me the page that tells me to fill my form again.what do i do?
December 02, 2004 - 8:45 am UTC
what does that have to do with "Doubts on Import/Export + temprary tablespace+shutdown/startup.
Not that you even describe the language or anything you are using (or how this relates to the database)
Not that we want you to put that information here -- since this has nothing whatsoever to do with the other text on this page.