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

Thread: Import with Full=y

  1. 11-25-2002, 04:57 PM #1
    san
    san is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 11-25-2002, 05:04 PM #2
    jlakhani's Avatar
    jlakhani
    jlakhani is offline Learn by breaking rdbms
    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."
    Reply With Quote Reply With Quote
  3. 11-25-2002, 05:39 PM #3
    launchpad
    launchpad is offline Member
    Join Date
    Jul 2000
    Posts
    119
    RTFM [I think we all know what rtfm means...marist89]
    Last edited by marist89; 11-25-2002 at 10:26 PM.
    OCP 8.0, 8i, 9i
    Reply With Quote Reply With Quote
  4. 11-25-2002, 06:12 PM #4
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width