full database import problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: full database import problem

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    full database import problem

    I Have oracle database 8.1.7.4 size 10gb running on sun solaris 8.


    Now i have asked to create new database of same size on different server OS is sun solaris 8 .

    I have created the new database which is of 10gb same as that of source database,

    took a full database dump from running database

    importing into freshly created database, but getting error unable to extent %table


    Could any one guide me how to proceed? why this error coming up?
    i have space constraints , cannot add datafile or auto extentd the file


    What my boss says is i want similar copy same as earlier existing running database.
    J Gangadhar

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    most likely you forgot to use compress=n in your export/import.

    personally, I would rather clone the database as long as it's the same OS. It's a lot quicker and you don't have to worry about space issues.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    Sounds like you blew out a tablespace. Can you attach the error log?
    I remember when this place was cool.

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    Re: full database import problem

    i have space constraints , cannot add datafile or auto extentd the file
    You've answered your own question

    Before you created the new database, did you make the tablespaces the same size as the orginal?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #5
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182
    yes, created all tablespaces same size as that of existing database
    J Gangadhar

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