DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002

    Import with Full=y

    I am trying to recreate a database with Import facility , I have exported this database with option Full=y .
    Created a database with same name with just one tablespace system and users sys and system .Created rollback segments and rollback tablespace too because it was complaining about rollback segments.

    My question is ...Is there any way that I can recreate this database completely even with out creating the initial database with system tablespace and sys & system users and rollback tablespace & rollback segments.

    All I want to execute is ...

    imp system/manager file=/backup/imp.dmp full=y log=/backup/imp.log

    Please let me know . Any suggestions also most welcome

    Thanks , san

  2. #2
    Join Date
    Aug 2000
    Chicago IL
    Well, if you take a cold backup you can restore it. You need to have a database to recreate the schemas
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Jul 2000
    RTFM [I think we all know what rtfm means...marist89]
    Last edited by marist89; 11-25-2002 at 09:26 PM.
    OCP 8.0, 8i, 9i

  4. #4
    Join Date
    Jan 2001
    San; As far as I know (and most would agree that ain't too far) you can only do that if you have IDENTICAL directory structures. Oracle will attempt to create the datafiles in the same EXACT directory as you export database. If the directory structure does not match then it can not create the datafiles and hence no tablespace.

    I usually try to set up the tablespaces ahead of time, makes it easier.

    I remember when this place was cool.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.