Re: Import problems on Windows Server

On Sep 26, 4:21 pm, zigzag...@xxxxxxxxx wrote:
I am using Oracle 9.2.0.6 on Windows 2000. I ran an import which takes
many hours. 1st time I ran import, it "finished". When I looked at
import log file, it did not complete import of all the tables.
Verified that whatever tables specified in import are the only tables
imported in database.

Deleted all the objects in schema and redid import. This time it went
beyond last time, import log file showed more tables. But then import
stopped writing to log file, however import was still going on. I
looked in database it has all the tables, views etc, so import
seems successful. Why import log was not updated? Import log time
stamp shows that lwriting to log was stopped 10 hours ago. Imp
process was still running,

I do not see any error messages written to alert log file or in
Windows event logs. What is going on? I have done import on Windows
server on several other databases, did not encounter such problems in
the past.

Are you running out of disk space? You might have preextended your
tablespaces so there is room there, but no room to write the log?
Then later, you couldn't write archived logs, freezing the db? Imp
waiting for db to unfreeze so it can continue? Do you have quotas?
Do you have large redologs? Fragmented disk misleading you about
space available? DMT's? Autoextend? Trying to reload slightly
larger objects than the ones they replaced?

If all else fails, maybe you need to drop user, drop tablespace,
shutdown Oracle, defragment disk, recreate ts, etc.

(I welcome any critique here.)

jg
--
@home.com is bogus.
http://www.wattflyer.com/forums/showthread.php?t=24932

.

Relevant Pages

  • Re: General Question
    ... Another thing to consider is the size your log file can ... grow to if your database is particularly busy. ... >another disk now. ...
    (microsoft.public.sqlserver.clients)
  • Re: How to attach db with missing log file?
    ... Start SQL Service ... Database fake will appear as suspect in EM ... I support PASS - the definitive, ... > allowing me to get past the missing log file, ...
    (microsoft.public.sqlserver.server)
  • RE: Shrink File?
    ... As my understanding of you problem, you have a database with a data file ... in the log file. ... You can truncate only nonactive portion of the transaction log. ...
    (microsoft.public.sqlserver.setup)
  • Re: PerfMon recording to SQL 2005
    ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Transaction log problems
    ... just before you backup the ... database change the recovery model to ... Simple, shrink the log file then change it back to Full, ... >transaction log and it is causing us some problems. ...
    (microsoft.public.sqlserver.server)