Re: Import problems on Windows Server

zigzagdna@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.

I've never seen this behavior but then I never run Oracle on Windows
for production. From that you may be able to draw your own conclusion. <g>
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • 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)
  • Re: sp_attach_single_file_db
    ... Being that Rob has access to the database and can still ... Stop sql server and rename the existing MDF to a new one and copy the ... Now execute the undocumented DBCC to create a log file ...
    (microsoft.public.sqlserver.server)