Import with Full=y
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import with Full=y

  1. #1
    Join Date
    Jan 2002
    Posts
    16

    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
    san

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    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
    Posts
    119
    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
    Posts
    3,131
    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.

    MH
    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