Importing a Full Export
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Importing a Full Export

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    I have a full export of a database which i need to import on a new server. I dont have the database, just Oracle software installed.

    What are the steps I need to follow to create a skeleton database and import the full export.

    Thanks
    Anurag

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    1. Create the target db (if it's not created yet)
    2. Configure the ts/dbf at target db to be that of the source db
    3. Configure rbs in target db
    4. Perform import.

  3. #3
    Join Date
    Sep 2000
    Posts
    362
    Hi ,
    Thanks for the reply.

    You mean to say that I need to create a database with the datafiles/tablespaces and segment names exactly the same as the source database. Wont this create a system table space and also create objects in it.

    Does this mean that you do not import the system user from the export.

    Thanks
    Anurag

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Well, you can just let the full export file create the db for you.

  5. #5
    Join Date
    Sep 2000
    Posts
    362
    How do I let the full export create the database for me.

    Thanks
    Anurag

  6. #6
    Join Date
    Sep 2000
    Posts
    362
    Any inputs on how will the export create a database for me.

    Thanks
    Anurag

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    The database can not be created by exp/imp, no way. You have to create the instance and the database manualy, only then can you execute the import. However you don't need to create the complete database, ie don't need to create all the tablespaces, users etc... Creating the database with a SYSTEM tablespace, an additional RB segment in sytem TS and users SYS and SYSTEM is sufficient, provided that imp will be able to create the datafiles exactly es they were in the original database (ie it will be able to create exactly the same directory structure for database files).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #8
    Join Date
    Sep 2000
    Posts
    362
    If we have to create a system table space manually then whats the use of it being exported in a full export. In any case export of the system tablespace is useless then.

    Thanks
    Anurag

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by anuragmin
    If we have to create a system table space manually then whats the use of it being exported in a full export. In any case export of the system tablespace is useless then.

    Thanks
    Anurag
    I'm affraid you'll have to dig into manuals a bit and try to find out what are the basic concepts of export and why is it used for.

    Unless your database is a total mess (meaning that any user appart from SYS has any object created in the system tablespace), nothing from the system tablespace is exported ever, no matter what kind of export you take. Remember that objects owned by SYS are never exported!
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    Below is a sample of the log file generated with a full export.
    According to jmodic system tablespace is not exported. I am not sure whether all of these are system tables but the ones with $ signs definitly should be.

    Also if these are not system tables then can i just go ahead and delete them without affecting the day to day database operation.

    Please confirm.

    Thanks
    Anurag


    Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
    With the Objects option
    PL/SQL Release 8.0.5.0.0 - Production
    Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

    About to export the entire database ...
    . exporting tablespace definitions
    . exporting profiles
    . exporting user definitions
    . exporting roles
    . exporting resource costs
    . exporting rollback segment definitions
    . exporting database links
    . exporting sequence numbers
    . exporting directory aliases
    . exporting foreign function library names
    . exporting object type definitions
    . exporting cluster definitions
    . about to export SYSTEM's tables via Conventional Path ...
    . . exporting table CHAINED_ROWS 1620 rows exported
    . . exporting table DEF$_AQCALL 0 rows exported
    . . exporting table DEF$_AQERROR 0 rows exported
    . . exporting table DEF$_CALL 0 rows exported
    . . exporting table DEF$_CALLDEST 0 rows exported
    . . exporting table DEF$_DEFAULTDEST 0 rows exported
    . . exporting table DEF$_DESTINATION 0 rows exported
    . . exporting table DEF$_ERROR 0 rows exported
    . . exporting table DEF$_LOB 0 rows exported
    . . exporting table DEF$_ORIGIN 0 rows exported
    . . exporting table DEF$_PROPAGATOR 0 rows exported
    . . exporting table DEF$_TEMP$LOB 0 rows exported
    . . exporting table EVT_CARRIER_CONFIGURATION 0 rows exported
    . . exporting table EVT_DEST_PROFILE 0 rows exported
    . . exporting table EVT_HISTORY 0 rows exported
    . . exporting table EVT_INSTANCE 0 rows exported
    . . exporting table EVT_MAIL_CONFIGURATION 0 rows exported
    . . exporting table EVT_MONITOR_NODE 0 rows exported
    . . exporting table EVT_NOTIFY_STATUS 0 rows exported
    . . exporting table EVT_OPERATORS 0 rows exported
    . . exporting table EVT_OPERATORS_ADDITIONAL 0 rows exported
    . . exporting table EVT_OPERATORS_SYSTEMS 0 rows exported
    . . exporting table EVT_OUTSTANDING 0 rows exported
    . . exporting table EVT_PROFILE 5 rows exported
    . . exporting table EVT_PROFILE_EVENTS 11 rows exported
    . . exporting table EVT_REGISTRY 2 rows exported
    . . exporting table EVT_REGISTRY_BACKLOG 0 rows exported
    . . exporting table PLAN_TABLE 0 rows exported
    . . exporting table SMACTUALPARAMETER_S 0 rows exported
    . . exporting table SMAGENTJOB_S 0 rows exported
    . . exporting table SMARCHIVE_S 0 rows exported
    . . exporting table SMBREAKABLELINKS 0 rows exported
    . . exporting table SMCLIQUE 0 rows exported
    . . exporting table SMCONFIGURATION 1 rows exported
    . . exporting table SMCONSOLESOSETTING_S 0 rows exported
    . . exporting table SMDATABASE_S 0 rows exported
    . . exporting table SMDBAUTH_S 0 rows exported
    . . exporting table SMDEFAUTH_S 0 rows exported
    . . exporting table SMDEPENDENTLINKS 0 rows exported
    . . exporting table SMDISTRIBUTIONSET_S 0 rows exported
    . . exporting table SMFOLDER_S 0 rows exported
    . . exporting table SMFORMALPARAMETER_S 17 rows exported
    . . exporting table SMGLOBALCONFIGURATION_S 0 rows exported
    . . exporting table SMHOSTAUTH_S 0 rows exported
    . . exporting table SMHOST_S 0 rows exported
    . . exporting table SMINSTALLATION_S 0 rows exported
    . . exporting table SMLOGMESSAGE_S 0 rows exported
    . . exporting table SMMONTHLYENTRY_S 0 rows exported
    . . exporting table SMMONTHWEEKENTRY_S 0 rows exported
    . . exporting table SMMOWNERLINKS 0 rows exported
    . . exporting table SMOMSTRING_S 2 rows exported
    . . exporting table SMOSNAMES_X 0 rows exported
    . . exporting table SMOWNERLINKS 19 rows exported
    . . exporting table SMPACKAGE_S 0 rows exported
    . . exporting table SMPARALLELJOB_S 0 rows exported
    . . exporting table SMPARALLELOPERATION_S 9 rows exported
    . . exporting table SMPARALLELSTATEMENT_S 0 rows exported
    . . exporting table SMPRODUCTATTRIBUTE_S 0 rows exported
    . . exporting table SMPRODUCT_S 0 rows exported
    . . exporting table SMP_AD_ADDRESSES_ 0 rows exported
    . . exporting table SMP_AD_DISCOVERED_NODES_ 0 rows exported
    . . exporting table SMP_AD_NODES_ 0 rows exported
    . . exporting table SMP_AD_PARMS_ 0 rows exported
    . . exporting table SMP_AUTO_DISCOVERY_ITEM_ 0 rows exported
    . . exporting table SMP_AUTO_DISCOVERY_PARMS_ 0 rows exported
    . . exporting table SMP_BLOB_ 9 rows exported
    . . exporting table SMP_BRM_ACTIVE_JOB_ 0 rows exported
    . . exporting table SMP_BRM_CHANNEL_DEVICE_ 0 rows exported
    . . exporting table SMP_BRM_DEFAULT_CHANNEL_ 0 rows exported
    . . exporting table SMP_BRM_RC_CONNECT_STRING_ 0 rows exported
    . . exporting table SMP_BRM_SAVED_JOB_ 0 rows exported
    . . exporting table SMP_BRM_TEMP_SCRIPTS_ 0 rows exported
    . . exporting table SMP_CREDENTIALS$ 0 rows exported
    . . exporting table SMP_EBU_ACTIVE_JOB_ 0 rows exported
    . . exporting table SMP_EBU_SAVED_JOB_ 0 rows exported
    . . exporting table SMP_JOB_ 0 rows exported
    . . exporting table SMP_JOB_EVENTLIST_ 0 rows exported
    . . exporting table SMP_JOB_HISTORY_ 0 rows exported
    . . exporting table SMP_JOB_INSTANCE_ 0 rows exported
    . . exporting table SMP_JOB_LIBRARY_ 0 rows exported
    . . exporting table SMP_JOB_TASK_INSTANCE_ 0 rows exported
    . . exporting table SMP_LONG_TEXT_ 0 rows exported
    . . exporting table SMP_REP_EXEC_STAT 0 rows exported
    . . exporting table SMP_REP_VERSION 2 rows exported
    . . exporting table SMP_SERVICES 1 rows exported
    . . exporting table SMP_SERVICE_DATA_ 0 rows exported
    . . exporting table SMP_SERVICE_GROUP_DEFN_ 0 rows exported
    . . exporting table SMP_SERVICE_GROUP_ITEM_ 0 rows exported
    . . exporting table SMP_SERVICE_ITEM_ 0 rows exported
    . . exporting table SMP_UPDATESERVICES_CALLED_ 0 rows exported
    . . exporting table SMP_USER_DETAILS 0 rows exported
    . . exporting table SMP_VAB_ACTIVE_JOB_ 0 rows exported
    . . exporting table SMP_VAB_SAVED_JOB_ 0 rows exported
    . . exporting table SMP_VAR_LIST_DATABASES_ 0 rows exported
    . . exporting table SMRELEASE_S 0 rows exported
    . . exporting table SMRUN_S 0 rows exported
    . . exporting table SMSCHEDULE_S 0 rows exported
    . . exporting table SMSHAREDORACLECLIENT_S 0 rows exported
    . . exporting table SMSHAREDORACLECONFIGURATION_S 0 rows exported
    . . exporting table SMTABLESPACE_S 0 rows exported
    . . exporting table SMVCENDPOINT_S 0 rows exported
    . . exporting table SMWEEKLYENTRY_S 0 rows exported
    . . exporting table SQLPLUS_PRODUCT_PROFILE 0 rows exported
    . . exporting table USER_PROFILE 0 rows exported
    . about to export DBSNMP's tables via Conventional Path ...
    . about to export MANDA's tables via Conventional Path ...
    . . exporting table ADVISOR 906 rows exported
    . . exporting table ASSET_DETAIL 5740 rows exported
    . . exporting table ASSET_PROPERTY 248 rows exported
    . . exporting table ASSET_TYPE 21 rows exported
    . . exporting table ATTRIBUTE 7 rows exported
    . . exporting table BUSINESS_FOCUS 8 rows exported
    . . exporting table COMPANY 7513 rows exported
    . . exporting table COMPANY_TYPE 42 rows exported
    . . exporting table COMPARABLE_TRANSACTIONS 781 rows exported
    . . exporting table CORPORATE_LINE_ITEM 2426 rows expo

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