DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBA Temp Tablesace

  1. #1
    Join Date
    Sep 2001
    Posts
    1

    Angry

    Respected Friends
    I am Dba since 1 year and today i have expeerienced an problem that i was inporting the data and at one stage oracle gave me an error that temporary segment full then i add a new temp data fiile in temporary tablespace and after some while it get larger and larger till fills the partition and oracle hanged. After restarting a message appear ORACLE NOT FOUND

    help me

  2. #2
    Join Date
    Jun 2000
    Posts
    179

    Talking

    try to start the database from the server manager as follows :

    * be sure to start the listener
    * initiate the service ( if working on NT/2000 )
    * start the server manager
    * connect internal and start up
    * if there is something wrong it will give back an error number thus will make it easy to trace the error

    I am assuming that you have a problem because the partition is filled , you may extend the partition if you are using windows 2000 in dynamic mode
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width