Attachment 318600 Details for Bug 464927 – Import log from test-db-3

Import log from test-db-3

9i->10gimport.log (text/plain), 60.07 KB, created by Steve Salevan on 2008-10-01 16:23:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Steve Salevan

Created: 2008-10-01 16:23:08 UTC

Size: 60.07 KB

patch

obsolete

>-bash-3.2$ imp "$ORAUSER/$ORAPWD" file=/tmp/$ORAUSER.dmp log=/tmp/$ORAUSER.implog fromuser=$ORAUSER touser=$ORAUSER ignore=y
>
>Import: Release 10.2.0.4.0 - Production on Wed Oct 1 11:46:14 2008
>
>Copyright (c) 1982, 2007, Oracle.  All rights reserved.
>
>
>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
>With the Partitioning, OLAP, Data Mining and Real Application Testing options
>
>Export file created by EXPORT:V09.02.00 via conventional path
>import done in US7ASCII character set and UTF8 NCHAR character set
>import server uses UTF8 character set (possible charset conversion)
>export client uses UTF8 character set (possible charset conversion)
>. importing SSALEVAN's objects into SSALEVAN
>. . importing table            "DB_CHANGE_HISTORY"          0 rows imported
>. . importing table     "DB_CHANGE_HISTORY_OUTPUT"          0 rows imported
>. . importing table        "DB_CHANGE_IGNORE_ERRS"          0 rows imported
>. . importing table               "DB_CHANGE_LOCK"          0 rows imported
>. . importing table          "DB_CHANGE_RESOURCES"          0 rows imported
>. . importing table   "DB_CHANGE_RESOURCE_CHANGES"          3 rows imported
>. . importing table     "DB_CHANGE_RESOURCE_NAMES"          0 rows imported
>. . importing table     "DB_CHANGE_RESOURCE_TYPES"         16 rows imported
>. . importing table             "DB_CHANGE_SCRIPT"          0 rows imported
>. . importing table    "DB_CHANGE_SCRIPT_EXPANDED"          0 rows imported
>. . importing table      "DB_CHANGE_SCRIPT_PARSED"          0 rows imported
>. . importing table      "DB_CHANGE_SCRIPT_SOURCE"          0 rows imported
>. . importing table                     "DEMO_LOG"          0 rows imported
>. . importing table                  "PXTSESSIONS"          2 rows imported
>. . importing table                    "RHNACTION"          6 rows imported
>. . importing table       "RHNACTIONCONFIGCHANNEL"          0 rows imported
>. . importing table          "RHNACTIONCONFIGDATE"          0 rows imported
>. . importing table      "RHNACTIONCONFIGDATEFILE"          0 rows imported
>. . importing table      "RHNACTIONCONFIGFILENAME"          0 rows imported
>. . importing table      "RHNACTIONCONFIGREVISION"          0 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNACTIONCONFIGREVISIONRESULT" ("ACTION_CONFIG_REVISION_ID" N"
> "UMBER CONSTRAINT "RHN_ACTIONCFR_ACRID_NN" NOT NULL ENABLE, "RESULT" BLOB, ""
> "CREATED" DATE CONSTRAINT "RHN_ACTIONCFR_CREAT_NN" NOT NULL ENABLE, "MODIFIE"
> "D" DATE CONSTRAINT "RHN_ACTIONCFR_MOD_NN" NOT NULL ENABLE)  PCTFREE 10 PCTU"
> "SED 40 INITRANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIS"
> "T GROUPS 1) TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("RESULT") STORE "
> "AS  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 "
> "NOCACHE  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table        "RHNACTIONDAEMONCONFIG"          0 rows imported
>. . importing table        "RHNACTIONERRATAUPDATE"          0 rows imported
>. . importing table           "RHNACTIONKICKSTART"          1 rows imported
>. . importing table   "RHNACTIONKICKSTARTFILELIST"          0 rows imported
>. . importing table      "RHNACTIONKICKSTARTGUEST"          0 rows imported
>. . importing table             "RHNACTIONPACKAGE"         10 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNACTIONPACKAGEANSWERFILE" ("ACTION_PACKAGE_ID" NUMBER CONST"
> "RAINT "RHN_ACT_P_AF_APID_NN" NOT NULL ENABLE, "ANSWERFILE" BLOB, "CREATED" "
> "DATE CONSTRAINT "RHN_ACT_P_AF_CREAT_NN" NOT NULL ENABLE, "MODIFIED" DATE CO"
> "NSTRAINT "RHN_ACT_P_AF_MOD_NN" NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INIT"
> "RANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS 1)"
> " TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("ANSWERFILE") STORE AS  (TA"
> "BLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE"
> "  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table        "RHNACTIONPACKAGEDELTA"          0 rows imported
>. . importing table        "RHNACTIONPACKAGEORDER"          0 rows imported
>. . importing table "RHNACTIONPACKAGEREMOVALFAILURE"          0 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNACTIONSCRIPT" ("ID" NUMBER CONSTRAINT "RHN_ACTSCRIPT_ID_NN"
> "" NOT NULL ENABLE, "ACTION_ID" NUMBER CONSTRAINT "RHN_ACTSCRIPT_AID_NN" NOT"
> " NULL ENABLE, "USERNAME" VARCHAR2(32) CONSTRAINT "RHN_ACTSCRIPT_USER_NN" NO"
> "T NULL ENABLE, "GROUPNAME" VARCHAR2(32) CONSTRAINT "RHN_ACTSCRIPT_GROUP_NN""
> " NOT NULL ENABLE, "SCRIPT" BLOB, "TIMEOUT" NUMBER, "CREATED" DATE CONSTRAIN"
> "T "RHN_ACTSCRIPT_CREAT_NN" NOT NULL ENABLE, "MODIFIED" DATE CONSTRAINT "RHN"
> "_ACTSCRIPT_MOD_NN" NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 32 MAXT"
> "RANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS 1) TABLESPACE "
> ""OTHER_TBS" LOGGING NOCOMPRESS LOB ("SCRIPT") STORE AS  (TABLESPACE "OTHER_"
> "TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAGE(INITIA"
> "L 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table              "RHNACTIONSTATUS"          4 rows imported
>. . importing table        "RHNACTIONTRANSACTIONS"          0 rows imported
>. . importing table                "RHNACTIONTYPE"         49 rows imported
>. . importing table         "RHNACTIONVIRTDESTROY"          0 rows imported
>. . importing table          "RHNACTIONVIRTREBOOT"          0 rows imported
>. . importing table         "RHNACTIONVIRTREFRESH"          0 rows imported
>. . importing table          "RHNACTIONVIRTRESUME"          0 rows imported
>. . importing table  "RHNACTIONVIRTSCHEDULEPOLLER"          0 rows imported
>. . importing table       "RHNACTIONVIRTSETMEMORY"          0 rows imported
>. . importing table        "RHNACTIONVIRTSHUTDOWN"          0 rows imported
>. . importing table           "RHNACTIONVIRTSTART"          0 rows imported
>. . importing table         "RHNACTIONVIRTSUSPEND"          0 rows imported
>. . importing table            "RHNACTIONVIRTVCPU"          0 rows imported
>. . importing table             "RHNACTIVATIONKEY"          1 rows imported
>. . importing table        "RHNAPPINSTALLINSTANCE"          0 rows imported
>. . importing table         "RHNAPPINSTALLSESSION"          0 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNAPPINSTALLSESSIONDATA" ("ID" NUMBER CONSTRAINT "RHN_APPINS"
> "T_SDATA_ID_NN" NOT NULL ENABLE, "SESSION_ID" NUMBER CONSTRAINT "RHN_APPINST"
> "_SDATA_SID_NN" NOT NULL ENABLE, "KEY" VARCHAR2(64) CONSTRAINT "RHN_APPINST_"
> "SDATA_K_NN" NOT NULL ENABLE, "VALUE" VARCHAR2(2048), "EXTRA_DATA" BLOB, "CR"
> "EATED" DATE CONSTRAINT "RHN_APPINST_SDATA_CREAT_NN" NOT NULL ENABLE, "MODIF"
> "IED" DATE CONSTRAINT "RHN_APPINST_SDATA_MOD_NN" NOT NULL ENABLE)  PCTFREE 1"
> "0 PCTUSED 40 INITRANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 F"
> "REELIST GROUPS 1) TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("EXTRA_DAT"
> "A") STORE AS  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTV"
> "ERSION 10 NOCACHE  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table                  "RHNARCHTYPE"          5 rows imported
>. . importing table           "RHNARCHTYPEACTIONS"         11 rows imported
>. . importing table            "RHNBEEHIVEPATHMAP"        276 rows imported
>. . importing table        "RHNBLACKLISTOBSOLETES"          6 rows imported
>. . importing table                   "RHNCHANNEL"          3 rows imported
>. . importing table               "RHNCHANNELARCH"         12 rows imported
>. . importing table             "RHNCHANNELCLONED"          0 rows imported
>. . importing table              "RHNCHANNELCOMPS"          0 rows imported
>. . importing table          "RHNCHANNELDOWNLOADS"          0 rows imported
>. . importing table             "RHNCHANNELERRATA"       1188 rows imported
>. . importing table             "RHNCHANNELFAMILY"         25 rows imported
>. . importing table      "RHNCHANNELFAMILYLICENSE"          0 rows imported
>. . importing table "RHNCHANNELFAMILYLICENSECONSENT"          0 rows imported
>. . importing table      "RHNCHANNELFAMILYMEMBERS"          3 rows imported
>. . importing table "RHNCHANNELFAMILYVIRTSUBLEVEL"         20 rows imported
>. . importing table      "RHNCHANNELNEWESTPACKAGE"       1947 rows imported
>. . importing table "RHNCHANNELNEWESTPACKAGEAUDIT"          5 rows imported
>. . importing table            "RHNCHANNELPACKAGE"       7320 rows imported
>. . importing table  "RHNCHANNELPACKAGEARCHCOMPAT"         78 rows imported
>. . importing table             "RHNCHANNELPARENT"          0 rows imported
>. . importing table         "RHNCHANNELPERMISSION"          0 rows imported
>. . importing table     "RHNCHANNELPERMISSIONROLE"          2 rows imported
>. . importing table            "RHNCHANNELPRODUCT"          0 rows imported
>. . importing table          "RHNCLIENTCAPABILITY"         13 rows imported
>. . importing table      "RHNCLIENTCAPABILITYNAME"         13 rows imported
>. . importing table             "RHNCONFIGCHANNEL"          1 rows imported
>. . importing table         "RHNCONFIGCHANNELTYPE"          3 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNCONFIGCONTENT" ("ID" NUMBER CONSTRAINT "RHN_CONFCONTENT_ID"
> "_NN" NOT NULL ENABLE, "CONTENTS" BLOB, "FILE_SIZE" NUMBER, "MD5SUM" VARCHAR"
> "2(64) CONSTRAINT "RHN_CONFCONTENT_MD5_NN" NOT NULL ENABLE, "IS_BINARY" CHAR"
> "(1) CONSTRAINT "RHN_CONFCONTENT_ISBIN_NN" NOT NULL ENABLE, "CREATED" DATE C"
> "ONSTRAINT "RHN_CONFCONTENT_CREAT_NN" NOT NULL ENABLE, "MODIFIED" DATE CONST"
> "RAINT "RHN_CONFCONTENT_MOD_NN" NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INIT"
> "RANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS 1)"
> " TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("CONTENTS") STORE AS  (TABL"
> "ESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  "
> "STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table                "RHNCONFIGFILE"          5 rows imported
>. . importing table         "RHNCONFIGFILEFAILURE"          4 rows imported
>. . importing table            "RHNCONFIGFILENAME"          5 rows imported
>. . importing table           "RHNCONFIGFILESTATE"          2 rows imported
>. . importing table            "RHNCONFIGFILETYPE"          2 rows imported
>. . importing table                "RHNCONFIGINFO"          1 rows imported
>. . importing table            "RHNCONFIGREVISION"          5 rows imported
>. . importing table                       "RHNCPU"          1 rows imported
>. . importing table                   "RHNCPUARCH"         22 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNCRYPTOKEY" ("ID" NUMBER CONSTRAINT "RHN_CRYPTOKEY_ID_NN" N"
> "OT NULL ENABLE, "ORG_ID" NUMBER CONSTRAINT "RHN_CRYPTOKEY_OID_NN" NOT NULL "
> "ENABLE, "DESCRIPTION" VARCHAR2(1024) CONSTRAINT "RHN_CRYPTOKEY_DESC_NN" NOT"
> " NULL ENABLE, "CRYPTO_KEY_TYPE_ID" NUMBER CONSTRAINT "RHN_CRYPTOKEY_CKTID_N"
> "N" NOT NULL ENABLE, "KEY" BLOB)  PCTFREE 10 PCTUSED 40 INITRANS 32 MAXTRANS"
> " 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS 1) TABLESPACE "OTH"
> "ER_TBS" LOGGING NOCOMPRESS LOB ("KEY") STORE AS  (TABLESPACE "OTHER_TBS" EN"
> "ABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAGE(INITIAL 13107"
> "2 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table        "RHNCRYPTOKEYKICKSTART"          1 rows imported
>. . importing table             "RHNCRYPTOKEYTYPE"          2 rows imported
>. . importing table             "RHNCUSTOMDATAKEY"          0 rows imported
>. . importing table                       "RHNCVE"       1078 rows imported
>. . importing table               "RHNDAEMONSTATE"         17 rows imported
>. . importing table         "RHNDAILYSUMMARYQUEUE"          0 rows imported
>. . importing table                    "RHNDEVICE"         15 rows imported
>. . importing table            "RHNDISTCHANNELMAP"          1 rows imported
>. . importing table                 "RHNDOWNLOADS"          0 rows imported
>. . importing table              "RHNDOWNLOADTYPE"          3 rows imported
>. . importing table              "RHNEMAILADDRESS"          2 rows imported
>. . importing table           "RHNEMAILADDRESSLOG"          0 rows imported
>. . importing table         "RHNEMAILADDRESSSTATE"          5 rows imported
>. . importing table            "RHNENTITLEMENTLOG"          0 rows imported
>. . importing table                    "RHNERRATA"       1188 rows imported
>. . importing table             "RHNERRATABUGLIST"       3301 rows imported
>. . importing table          "RHNERRATABUGLISTTMP"          0 rows imported
>. . importing table              "RHNERRATACLONED"          0 rows imported
>. . importing table           "RHNERRATACLONEDTMP"          0 rows imported
>. . importing table                 "RHNERRATACVE"       1474 rows imported
>. . importing table                "RHNERRATAFILE"      77108 rows imported
>. . importing table         "RHNERRATAFILECHANNEL"       5110 rows imported
>. . importing table      "RHNERRATAFILECHANNELTMP"          0 rows imported
>. . importing table         "RHNERRATAFILEPACKAGE"      20728 rows imported
>. . importing table   "RHNERRATAFILEPACKAGESOURCE"          0 rows imported
>. . importing table      "RHNERRATAFILEPACKAGETMP"          0 rows imported
>. . importing table             "RHNERRATAFILETMP"          0 rows imported
>. . importing table            "RHNERRATAFILETYPE"          3 rows imported
>. . importing table             "RHNERRATAKEYWORD"       1091 rows imported
>. . importing table          "RHNERRATAKEYWORDTMP"          0 rows imported
>. . importing table   "RHNERRATANOTIFICATIONQUEUE"       1188 rows imported
>. . importing table             "RHNERRATAPACKAGE"       3875 rows imported
>. . importing table          "RHNERRATAPACKAGETMP"          0 rows imported
>. . importing table               "RHNERRATAQUEUE"          0 rows imported
>. . importing table            "RHNERRATASEVERITY"          4 rows imported
>. . importing table                 "RHNERRATATMP"          0 rows imported
>. . importing table                 "RHNEXCEPTION"         67 rows imported
>. . importing table                       "RHNFAQ"         64 rows imported
>. . importing table                  "RHNFAQCLASS"         10 rows imported
>. . importing table                   "RHNFEATURE"         27 rows imported
>. . importing table                      "RHNFILE"          0 rows imported
>. . importing table              "RHNFILEDOWNLOAD"          0 rows imported
>. . importing table                  "RHNFILELIST"          0 rows imported
>. . importing table           "RHNFILELISTMEMBERS"          0 rows imported
>. . importing table              "RHNFILELOCATION"          0 rows imported
>. . importing table     "RHNGRAILCOMPONENTCHOICES"          0 rows imported
>. . importing table           "RHNGRAILCOMPONENTS"          0 rows imported
>. . importing table               "RHNINDEXERWORK"          1 rows imported
>. . importing table                  "RHNINFOPANE"          9 rows imported
>. . importing table         "RHNKICKSTARTABLETREE"          8 rows imported
>. . importing table     "RHNKICKSTARTCHILDCHANNEL"          0 rows imported
>. . importing table          "RHNKICKSTARTCOMMAND"         23 rows imported
>. . importing table      "RHNKICKSTARTCOMMANDNAME"         54 rows imported
>. . importing table  "RHNKICKSTARTDEFAULTREGTOKEN"          0 rows imported
>. . importing table         "RHNKICKSTARTDEFAULTS"          1 rows imported
>. . importing table          "RHNKICKSTARTIPRANGE"          0 rows imported
>. . importing table          "RHNKICKSTARTPACKAGE"          1 rows imported
>. . importing table "RHNKICKSTARTPRESERVEFILELIST"          0 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNKICKSTARTSCRIPT" ("ID" NUMBER CONSTRAINT "RHN_KSSCRIPT_ID_"
> "NN" NOT NULL ENABLE, "KICKSTART_ID" NUMBER CONSTRAINT "RHN_KSSCRIPT_KSID_NN"
> "" NOT NULL ENABLE, "POSITION" NUMBER CONSTRAINT "RHN_KSSCRIPT_POS_NN" NOT N"
> "ULL ENABLE, "SCRIPT_TYPE" VARCHAR2(4) CONSTRAINT "RHN_KSSCRIPT_ST_NN" NOT N"
> "ULL ENABLE, "CHROOT" CHAR(1) CONSTRAINT "RHN_KSSCRIPT_CHROOT_NN" NOT NULL E"
> "NABLE, "INTERPRETER" VARCHAR2(80), "DATA" BLOB, "CREATED" DATE CONSTRAINT ""
> "RHN_KSSCRIPT_CREAT_NN" NOT NULL ENABLE, "MODIFIED" DATE CONSTRAINT "RHN_KSS"
> "CRIPT_MOD_NN" NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 32 MAXTRANS "
> "255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS 1) TABLESPACE "OTHE"
> "R_TBS" LOGGING NOCOMPRESS LOB ("DATA") STORE AS  (TABLESPACE "OTHER_TBS" EN"
> "ABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAGE(INITIAL 13107"
> "2 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table          "RHNKICKSTARTSESSION"          1 rows imported
>. . importing table   "RHNKICKSTARTSESSIONHISTORY"          4 rows imported
>. . importing table     "RHNKICKSTARTSESSIONSTATE"         13 rows imported
>. . importing table         "RHNKICKSTARTTIMEZONE"       1500 rows imported
>. . importing table "RHNKICKSTARTVIRTUALIZATIONTYPE"          3 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNKSDATA" ("ID" NUMBER CONSTRAINT "RHN_KS_ID_NN" NOT NULL EN"
> "ABLE, "ORG_ID" NUMBER CONSTRAINT "RHN_KS_OID_NN" NOT NULL ENABLE, "IS_ORG_D"
> "EFAULT" CHAR(1) CONSTRAINT "RHN_KS_DEFAULT_NN" NOT NULL ENABLE, "LABEL" VAR"
> "CHAR2(64) CONSTRAINT "RHN_KS_LABEL_NN" NOT NULL ENABLE, "NAME" VARCHAR2(128"
> ") CONSTRAINT "RHN_KS_NAME_NN" NOT NULL ENABLE, "COMMENTS" VARCHAR2(4000), ""
> "ACTIVE" CHAR(1) CONSTRAINT "RHN_KS_ACTIVE_NN" NOT NULL ENABLE, "POSTLOG" CH"
> "AR(1) CONSTRAINT "RHN_KS_POST_LOG_NN" NOT NULL ENABLE, "PRE" BLOB, "POST" B"
> "LOB, "NOCHROOT_POST" BLOB, "STATIC_DEVICE" VARCHAR2(32), "KERNEL_PARAMS" VA"
> "RCHAR2(128), "CREATED" DATE CONSTRAINT "RHN_KS_CREATED_NN" NOT NULL ENABLE,"
> " "MODIFIED" DATE CONSTRAINT "RHN_KS_MODIFIED_NN" NOT NULL ENABLE)  PCTFREE "
> "10 PCTUSED 40 INITRANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 "
> "FREELIST GROUPS 1) TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("PRE") ST"
> "ORE AS  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION"
> " 10 NOCACHE  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1)) LOB ("P"
> "OST") STORE AS  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PC"
> "TVERSION 10 NOCACHE  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
> " LOB ("NOCHROOT_POST") STORE AS  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN "
> "ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAGE(INITIAL 131072 FREELISTS 1 FR"
> "EELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table             "RHNKSINSTALLTYPE"          4 rows imported
>. . importing table                "RHNKSTREEFILE"       1034 rows imported
>. . importing table                "RHNKSTREETYPE"          2 rows imported
>. . importing table                   "RHNMESSAGE"          0 rows imported
>. . importing table           "RHNMESSAGEPRIORITY"          2 rows imported
>. . importing table               "RHNMESSAGETYPE"          1 rows imported
>. . importing table                   "RHNMONITOR"          0 rows imported
>. . importing table        "RHNMONITORGRANULARITY"          1 rows imported
>. . importing table        "RHNORGCHANNELSETTINGS"          0 rows imported
>. . importing table    "RHNORGCHANNELSETTINGSTYPE"          1 rows imported
>. . importing table           "RHNORGENTITLEMENTS"          8 rows imported
>. . importing table        "RHNORGENTITLEMENTTYPE"          6 rows imported
>. . importing table       "RHNORGERRATACACHEQUEUE"          0 rows imported
>. . importing table                   "RHNORGINFO"          0 rows imported
>. . importing table                  "RHNORGQUOTA"          2 rows imported
>. . importing table                   "RHNPACKAGE"       7320 rows imported
>. . importing table               "RHNPACKAGEARCH"         38 rows imported
>. . importing table         "RHNPACKAGECAPABILITY"    1176848 rows imported
>. . importing table          "RHNPACKAGECHANGELOG"     847367 rows imported
>. . importing table          "RHNPACKAGECONFLICTS"       3668 rows imported
>. . importing table              "RHNPACKAGEDELTA"          0 rows imported
>. . importing table       "RHNPACKAGEDELTAELEMENT"          0 rows imported
>. . importing table                "RHNPACKAGEEVR"       2387 rows imported
>. . importing table               "RHNPACKAGEFILE"    2213098 rows imported
>. . importing table    "RHNPACKAGEFILEDELETEQUEUE"          0 rows imported
>. . importing table              "RHNPACKAGEGROUP"         51 rows imported
>. . importing table               "RHNPACKAGENAME"       1951 rows imported
>. . importing table              "RHNPACKAGENEVRA"       7631 rows imported
>. . importing table          "RHNPACKAGEOBSOLETES"       4358 rows imported
>. . importing table           "RHNPACKAGEPROVIDES"      60156 rows imported
>. . importing table           "RHNPACKAGEREQUIRES"     117753 rows imported
>. . importing table              "RHNPACKAGESENSE"         27 rows imported
>. . importing table           "RHNPACKAGESENSEMAP"          0 rows imported
>. . importing table          "RHNPACKAGESIGNATURE"          0 rows imported
>. . importing table            "RHNPACKAGESIGTYPE"          4 rows imported
>. . importing table             "RHNPACKAGESOURCE"          0 rows imported
>. . importing table      "RHNPACKAGESYNCBLACKLIST"          3 rows imported
>. . importing table            "RHNPATHCHANNELMAP"          0 rows imported
>. . importing table      "RHNPRIVATECHANNELFAMILY"         43 rows imported
>. . importing table                   "RHNPRODUCT"          0 rows imported
>. . importing table            "RHNPRODUCTCHANNEL"          0 rows imported
>. . importing table               "RHNPRODUCTLINE"          4 rows imported
>. . importing table               "RHNPRODUCTNAME"         85 rows imported
>. . importing table            "RHNPROVISIONSTATE"          0 rows imported
>. . importing table                 "RHNPROXYINFO"          0 rows imported
>. . importing table       "RHNPUBLICCHANNELFAMILY"          1 rows imported
>. . importing table                "RHNPUSHCLIENT"          0 rows imported
>. . importing table           "RHNPUSHCLIENTSTATE"          2 rows imported
>. . importing table            "RHNPUSHDISPATCHER"          1 rows imported
>. . importing table                       "RHNRAM"          1 rows imported
>. . importing table        "RHNREDHATCANONVERSION"         36 rows imported
>. . importing table                  "RHNREGTOKEN"          1 rows imported
>. . importing table          "RHNREGTOKENCHANNELS"          2 rows imported
>. . importing table    "RHNREGTOKENCONFIGCHANNELS"          0 rows imported
>. . importing table       "RHNREGTOKENENTITLEMENT"          3 rows imported
>. . importing table            "RHNREGTOKENGROUPS"          0 rows imported
>. . importing table        "RHNREGTOKENORGDEFAULT"          0 rows imported
>. . importing table          "RHNREGTOKENPACKAGES"          0 rows imported
>. . importing table          "RHNRELATIONSHIPTYPE"          1 rows imported
>. . importing table         "RHNRELEASECHANNELMAP"          0 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNSATELLITECERT" ("LABEL" VARCHAR2(64) CONSTRAINT "RHN_SATCE"
> "RT_LABEL_NN" NOT NULL ENABLE, "VERSION" NUMBER, "CERT" BLOB CONSTRAINT "RHN"
> "_SATCERT_CERT_NN" NOT NULL ENABLE, "ISSUED" DATE, "EXPIRES" DATE, "CREATED""
> " DATE CONSTRAINT "RHN_SATCERT_CREATED_NN" NOT NULL ENABLE, "MODIFIED" DATE "
> "CONSTRAINT "RHN_SATCERT_MODIFIED_NN" NOT NULL ENABLE)  PCTFREE 10 PCTUSED 4"
> "0 INITRANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GRO"
> "UPS 1) TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("CERT") STORE AS  (TA"
> "BLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE"
> "  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table    "RHNSATELLITECHANNELFAMILY"          0 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNSATELLITEINFO" ("SERVER_ID" NUMBER CONSTRAINT "RHN_SATELLI"
> "TE_INFO_SID_NN" NOT NULL ENABLE, "EVR_ID" NUMBER, "CERT" BLOB CONSTRAINT "R"
> "HN_SATELLITE_INFO_CERT_NN" NOT NULL ENABLE, "PRODUCT" VARCHAR2(256) CONSTRA"
> "INT "RHN_SATELLITE_INFO_PRODUCT_NN" NOT NULL ENABLE, "OWNER" VARCHAR2(256) "
> "CONSTRAINT "RHN_SATELLITE_INFO_OWNER_NN" NOT NULL ENABLE, "ISSUED_STRING" V"
> "ARCHAR2(256), "EXPIRATION_STRING" VARCHAR2(256), "CREATED" DATE CONSTRAINT "
> ""RHN_SATELLITE_INFO_CREATED_NN" NOT NULL ENABLE, "MODIFIED" DATE CONSTRAINT"
> " "RHN_SATELLITE_INFO_MODIFIED_NN" NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 I"
> "NITRANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS"
> " 1) TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("CERT") STORE AS  (TABLE"
> "SPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  S"
> "TORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table      "RHNSATELLITESERVERGROUP"          0 rows imported
>. . importing table               "RHNSAVEDSEARCH"          0 rows imported
>. . importing table           "RHNSAVEDSEARCHTYPE"          3 rows imported
>. . importing table                    "RHNSERVER"          1 rows imported
>. . importing table              "RHNSERVERACTION"          1 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNSERVERACTIONPACKAGERESULT" ("SERVER_ID" NUMBER CONSTRAINT "
> ""RHN_SAP_RESULT_SID_NN" NOT NULL ENABLE, "ACTION_PACKAGE_ID" NUMBER CONSTRA"
> "INT "RHN_SAP_RESULT_APID_NN" NOT NULL ENABLE, "RESULT_CODE" NUMBER CONSTRAI"
> "NT "RHN_SAP_RESULT_RC_NN" NOT NULL ENABLE, "STDOUT" BLOB, "STDERR" BLOB, "C"
> "REATED" DATE CONSTRAINT "RHN_SAP_RESULT_CREAT_NN" NOT NULL ENABLE, "MODIFIE"
> "D" DATE CONSTRAINT "RHN_SAP_RESULT_MOD_NN" NOT NULL ENABLE)  PCTFREE 10 PCT"
> "USED 40 INITRANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELI"
> "ST GROUPS 1) TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("STDOUT") STORE"
> " AS  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10"
> " NOCACHE  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1)) LOB ("STDE"
> "RR") STORE AS  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCT"
> "VERSION 10 NOCACHE  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNSERVERACTIONSCRIPTRESULT" ("SERVER_ID" NUMBER CONSTRAINT ""
> "RHN_SERVERAS_RESULT_SID_NN" NOT NULL ENABLE, "ACTION_SCRIPT_ID" NUMBER CONS"
> "TRAINT "RHN_SERVERAS_RESULT_ASID_NN" NOT NULL ENABLE, "OUTPUT" BLOB, "START"
> "_DATE" DATE CONSTRAINT "RHN_SERVERAS_RESULT_START_NN" NOT NULL ENABLE, "STO"
> "P_DATE" DATE CONSTRAINT "RHN_SERVERAS_RESULT_STOP_NN" NOT NULL ENABLE, "RET"
> "URN_CODE" NUMBER CONSTRAINT "RHN_SERVERAS_RESULT_RETURN_NN" NOT NULL ENABLE"
> ", "CREATED" DATE CONSTRAINT "RHN_SERVERAS_RESULT_CREAT_NN" NOT NULL ENABLE,"
> " "MODIFIED" DATE CONSTRAINT "RHN_SERVERAS_RESULT_MOD_NN" NOT NULL ENABLE)  "
> "PCTFREE 10 PCTUSED 40 INITRANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREEL"
> "ISTS 16 FREELIST GROUPS 1) TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB (""
> "OUTPUT") STORE AS  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192"
> " PCTVERSION 10 NOCACHE  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS "
> "1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table "RHNSERVERACTIONVERIFYMISSING"          0 rows imported
>. . importing table  "RHNSERVERACTIONVERIFYRESULT"          0 rows imported
>. . importing table                "RHNSERVERARCH"         25 rows imported
>. . importing table           "RHNSERVERCACHEINFO"          0 rows imported
>. . importing table             "RHNSERVERCHANNEL"          3 rows imported
>. . importing table   "RHNSERVERCHANNELARCHCOMPAT"         23 rows imported
>. . importing table       "RHNSERVERCONFIGCHANNEL"          0 rows imported
>. . importing table     "RHNSERVERCUSTOMDATAVALUE"          0 rows imported
>. . importing table                 "RHNSERVERDMI"          1 rows imported
>. . importing table               "RHNSERVEREVENT"          0 rows imported
>. . importing table               "RHNSERVERGROUP"         13 rows imported
>. . importing table        "RHNSERVERGROUPMEMBERS"          4 rows imported
>. . importing table          "RHNSERVERGROUPNOTES"          0 rows imported
>. . importing table           "RHNSERVERGROUPTYPE"          7 rows imported
>. . importing table    "RHNSERVERGROUPTYPEFEATURE"         31 rows imported
>. . importing table             "RHNSERVERHISTORY"          6 rows imported
>. . importing table                "RHNSERVERINFO"          1 rows imported
>. . importing table         "RHNSERVERINSTALLINFO"          1 rows imported
>. . importing table            "RHNSERVERLOCATION"          1 rows imported
>. . importing table                "RHNSERVERLOCK"          0 rows imported
>. . importing table             "RHNSERVERMESSAGE"          0 rows imported
>. . importing table   "RHNSERVERNEEDEDERRATACACHE"          0 rows imported
>. . importing table  "RHNSERVERNEEDEDPACKAGECACHE"         10 rows imported
>. . importing table        "RHNSERVERNETINTERFACE"          4 rows imported
>. . importing table             "RHNSERVERNETWORK"          1 rows imported
>. . importing table               "RHNSERVERNOTES"          0 rows imported
>. . importing table             "RHNSERVERPACKAGE"        311 rows imported
>. . importing table   "RHNSERVERPACKAGEARCHCOMPAT"        106 rows imported
>. . importing table                "RHNSERVERPATH"          0 rows imported
>. . importing table    "RHNSERVERPRESERVEFILELIST"          0 rows imported
>. . importing table             "RHNSERVERPROFILE"          0 rows imported
>. . importing table      "RHNSERVERPROFILEPACKAGE"          0 rows imported
>. . importing table         "RHNSERVERPROFILETYPE"          2 rows imported
>. . importing table "RHNSERVERSERVERGROUPARCHCOMPAT"        113 rows imported
>. . importing table           "RHNSERVERTOKENREGS"          0 rows imported
>. . importing table                "RHNSERVERUUID"          1 rows imported
>. . importing table                       "RHNSET"          2 rows imported
>. . importing table     "RHNSGTYPEBASEADDONCOMPAT"          6 rows imported
>. . importing table        "RHNSGTYPEVIRTSUBLEVEL"          2 rows imported
>. . importing table                  "RHNSNAPSHOT"          5 rows imported
>. . importing table           "RHNSNAPSHOTCHANNEL"         12 rows imported
>. . importing table     "RHNSNAPSHOTCONFIGCHANNEL"          0 rows imported
>. . importing table    "RHNSNAPSHOTCONFIGREVISION"          0 rows imported
>. . importing table     "RHNSNAPSHOTINVALIDREASON"          6 rows imported
>. . importing table           "RHNSNAPSHOTPACKAGE"       1553 rows imported
>. . importing table       "RHNSNAPSHOTSERVERGROUP"         17 rows imported
>. . importing table               "RHNSNAPSHOTTAG"          0 rows imported
>. . importing table            "RHNSNPERRATAQUEUE"          0 rows imported
>. . importing table            "RHNSNPSERVERQUEUE"          0 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNSOLARISPACKAGE" ("PACKAGE_ID" NUMBER, "CATEGORY" VARCHAR2("
> "2048) CONSTRAINT "RHN_SOLARIS_PKG_CAT_NN" NOT NULL ENABLE, "PKGINFO" VARCHA"
> "R2(4000), "PKGMAP" BLOB, "INTONLY" CHAR(1))  PCTFREE 10 PCTUSED 40 INITRANS"
> " 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS 1) TAB"
> "LESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("PKGMAP") STORE AS  (TABLESPACE"
> " "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAG"
> "E(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNSOLARISPATCH" ("PACKAGE_ID" NUMBER, "SOLARIS_RELEASE" VARC"
> "HAR2(64), "SUNOS_RELEASE" VARCHAR2(64), "PATCH_TYPE" NUMBER CONSTRAINT "RHN"
> "_SOLARIS_P_PT_NN" NOT NULL ENABLE, "CREATED" DATE CONSTRAINT "RHN_SOLARIS_P"
> "_CREATED_NN" NOT NULL ENABLE, "MODIFIED" DATE CONSTRAINT "RHN_SOLARIS_P_MOD"
> "IFIED_NN" NOT NULL ENABLE, "README" BLOB CONSTRAINT "RHN_SOLARIS_P_RDME_NN""
> " NOT NULL ENABLE, "PATCHINFO" VARCHAR2(4000))  PCTFREE 10 PCTUSED 40 INITRA"
> "NS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST GROUPS 1) T"
> "ABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("README") STORE AS  (TABLESPA"
> "CE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STOR"
> "AGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table     "RHNSOLARISPATCHEDPACKAGE"          0 rows imported
>. . importing table      "RHNSOLARISPATCHPACKAGES"          0 rows imported
>IMP-00017: following statement failed with ORACLE error 959:
> "CREATE TABLE "RHNSOLARISPATCHSET" ("PACKAGE_ID" NUMBER, "README" BLOB, "SET"
> "_DATE" DATE CONSTRAINT "RHN_SOLARIS_PS_SD_NN" NOT NULL ENABLE, "CREATED" DA"
> "TE CONSTRAINT "RHN_SOLARIS_PS_CREATED_NN" NOT NULL ENABLE, "MODIFIED" DATE "
> "CONSTRAINT "RHN_SOLARIS_PS_MODIFIED_NN" NOT NULL ENABLE)  PCTFREE 10 PCTUSE"
> "D 40 INITRANS 32 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 16 FREELIST "
> "GROUPS 1) TABLESPACE "OTHER_TBS" LOGGING NOCOMPRESS LOB ("README") STORE AS"
> "  (TABLESPACE "OTHER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NO"
> "CACHE  STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1))"
>IMP-00003: ORACLE error 959 encountered
>ORA-00959: tablespace 'OTHER_TBS' does not exist
>. . importing table    "RHNSOLARISPATCHSETMEMBERS"          0 rows imported
>. . importing table          "RHNSOLARISPATCHTYPE"          6 rows imported
>. . importing table                 "RHNSOURCERPM"       2437 rows imported
>. . importing table                       "RHNTAG"          0 rows imported
>. . importing table                   "RHNTAGNAME"          0 rows imported
>. . importing table                 "RHNTASKQUEUE"          0 rows imported
>. . importing table          "RHNTEMPLATECATEGORY"          2 rows imported
>. . importing table            "RHNTEMPLATESTRING"          3 rows imported
>. . importing table               "RHNTEXTMESSAGE"          0 rows imported
>. . importing table                  "RHNTIMEZONE"         37 rows imported
>. . importing table                   "RHNTINYURL"          1 rows imported
>. . importing table               "RHNTRANSACTION"          0 rows imported
>. . importing table        "RHNTRANSACTIONELEMENT"          0 rows imported
>. . importing table      "RHNTRANSACTIONOPERATION"          3 rows imported
>. . importing table        "RHNTRANSACTIONPACKAGE"          0 rows imported
>. . importing table   "RHNUSERDEFAULTSYSTEMGROUPS"          0 rows imported
>. . importing table                 "RHNUSERGROUP"         17 rows imported
>. . importing table          "RHNUSERGROUPMEMBERS"          3 rows imported
>. . importing table             "RHNUSERGROUPTYPE"         14 rows imported
>. . importing table                  "RHNUSERINFO"          2 rows imported
>. . importing table              "RHNUSERINFOPANE"          0 rows imported
>. . importing table               "RHNUSERMESSAGE"          0 rows imported
>. . importing table         "RHNUSERMESSAGESTATUS"          3 rows imported
>. . importing table           "RHNUSERMESSAGETYPE"          0 rows imported
>. . importing table              "RHNUSERRESERVED"          0 rows imported
>. . importing table      "RHNUSERSERVERGROUPPERMS"          1 rows imported
>. . importing table           "RHNUSERSERVERPERMS"          1 rows imported
>. . importing table           "RHNUSERSERVERPREFS"          0 rows imported
>. . importing table               "RHNVERSIONINFO"          1 rows imported
>. . importing table              "RHNVIRTSUBLEVEL"          2 rows imported
>. . importing table           "RHNVIRTUALINSTANCE"          0 rows imported
>. . importing table   "RHNVIRTUALINSTANCEEVENTLOG"          0 rows imported
>. . importing table  "RHNVIRTUALINSTANCEEVENTTYPE"          8 rows imported
>. . importing table       "RHNVIRTUALINSTANCEINFO"          0 rows imported
>. . importing table "RHNVIRTUALINSTANCEINSTALLLOG"          0 rows imported
>. . importing table      "RHNVIRTUALINSTANCESTATE"          5 rows imported
>. . importing table       "RHNVIRTUALINSTANCETYPE"          2 rows imported
>. . importing table            "RHNVISIBLEOBJECTS"          0 rows imported
>. . importing table       "RHNWEBCONTACTCHANGELOG"          0 rows imported
>. . importing table     "RHNWEBCONTACTCHANGESTATE"          2 rows imported
>. . importing table              "RHN_CHECK_PROBE"          4 rows imported
>. . importing table             "RHN_CHECK_SUITES"          0 rows imported
>. . importing table        "RHN_CHECK_SUITE_PROBE"          0 rows imported
>. . importing table                  "RHN_COMMAND"         78 rows imported
>. . importing table     "RHN_COMMAND_CENTER_STATE"          0 rows imported
>. . importing table            "RHN_COMMAND_CLASS"         68 rows imported
>. . importing table           "RHN_COMMAND_GROUPS"         10 rows imported
>. . importing table        "RHN_COMMAND_PARAMETER"        708 rows imported
>. . importing table  "RHN_COMMAND_PARAM_THRESHOLD"        242 rows imported
>. . importing table   "RHN_COMMAND_QUEUE_COMMANDS"          3 rows imported
>. . importing table      "RHN_COMMAND_QUEUE_EXECS"          1 rows imported
>. . importing table   "RHN_COMMAND_QUEUE_EXECS_BK"          0 rows imported
>. . importing table  "RHN_COMMAND_QUEUE_INSTANCES"          1 rows imported
>. . importing table "RHN_COMMAND_QUEUE_INSTANCES_BK"          0 rows imported
>. . importing table     "RHN_COMMAND_QUEUE_PARAMS"          0 rows imported
>. . importing table   "RHN_COMMAND_QUEUE_SESSIONS"          0 rows imported
>. . importing table     "RHN_COMMAND_REQUIREMENTS"          6 rows imported
>. . importing table           "RHN_COMMAND_TARGET"          2 rows imported
>. . importing table             "RHN_CONFIG_GROUP"         28 rows imported
>. . importing table             "RHN_CONFIG_MACRO"         55 rows imported
>. . importing table         "RHN_CONFIG_PARAMETER"        195 rows imported
>. . importing table     "RHN_CONFIG_SECURITY_TYPE"          3 rows imported
>. . importing table           "RHN_CONTACT_GROUPS"          1 rows imported
>. . importing table    "RHN_CONTACT_GROUP_MEMBERS"          1 rows imported
>. . importing table          "RHN_CONTACT_METHODS"          1 rows imported
>. . importing table           "RHN_CURRENT_ALERTS"          0 rows imported
>. . importing table  "RHN_CURRENT_STATE_SUMMARIES"          0 rows imported
>. . importing table           "RHN_DB_ENVIRONMENT"          1 rows imported
>. . importing table           "RHN_DEPLOYED_PROBE"          4 rows imported
>. . importing table              "RHN_ENVIRONMENT"          2 rows imported
>. . importing table        "RHN_HOST_CHECK_SUITES"          0 rows imported
>. . importing table               "RHN_HOST_PROBE"          0 rows imported
>. . importing table     "RHN_INTERFACE_MONITORING"          0 rows imported
>. . importing table              "RHN_LL_NETSAINT"          0 rows imported
>. . importing table             "RHN_METHOD_TYPES"          4 rows imported
>. . importing table                  "RHN_METRICS"        101 rows imported
>. . importing table    "RHN_MULTI_SCOUT_THRESHOLD"          0 rows imported
>. . importing table     "RHN_NOTIFICATION_FORMATS"          4 rows imported
>. . importing table             "RHN_NOTIFSERVERS"          0 rows imported
>. . importing table                       "RHN_OS"          2 rows imported
>. . importing table         "RHN_OS_COMMANDS_XREF"        101 rows imported
>. . importing table              "RHN_PAGER_TYPES"          1 rows imported
>. . importing table        "RHN_PHYSICAL_LOCATION"          1 rows imported
>. . importing table                    "RHN_PROBE"          4 rows imported
>. . importing table        "RHN_PROBE_PARAM_VALUE"         32 rows imported
>. . importing table              "RHN_PROBE_STATE"          4 rows imported
>. . importing table              "RHN_PROBE_TYPES"          7 rows imported
>. . importing table                   "RHN_QUANTA"         13 rows imported
>. . importing table                "RHN_REDIRECTS"          0 rows imported
>. . importing table        "RHN_REDIRECT_CRITERIA"          0 rows imported
>. . importing table   "RHN_REDIRECT_EMAIL_TARGETS"          0 rows imported
>. . importing table   "RHN_REDIRECT_GROUP_TARGETS"          0 rows imported
>. . importing table     "RHN_REDIRECT_MATCH_TYPES"         10 rows imported
>. . importing table  "RHN_REDIRECT_METHOD_TARGETS"          0 rows imported
>. . importing table           "RHN_REDIRECT_TYPES"          4 rows imported
>. . importing table          "RHN_SATELLITE_STATE"          1 rows imported
>. . importing table              "RHN_SAT_CLUSTER"          1 rows imported
>. . importing table        "RHN_SAT_CLUSTER_PROBE"          0 rows imported
>. . importing table                 "RHN_SAT_NODE"          1 rows imported
>. . importing table           "RHN_SAT_NODE_PROBE"          0 rows imported
>. . importing table                "RHN_SCHEDULES"          1 rows imported
>. . importing table            "RHN_SCHEDULE_DAYS"          7 rows imported
>. . importing table       "RHN_SCHEDULE_DAYS_NORM"          0 rows imported
>. . importing table           "RHN_SCHEDULE_TYPES"          3 rows imported
>. . importing table           "RHN_SCHEDULE_WEEKS"          0 rows imported
>. . importing table       "RHN_SEMANTIC_DATA_TYPE"          7 rows imported
>. . importing table   "RHN_SERVER_MONITORING_INFO"          0 rows imported
>. . importing table    "RHN_SERVICE_PROBE_ORIGINS"          0 rows imported
>. . importing table               "RHN_SNMP_ALERT"          0 rows imported
>. . importing table               "RHN_STRATEGIES"          6 rows imported
>. . importing table           "RHN_THRESHOLD_TYPE"          4 rows imported
>. . importing table          "RHN_TIME_ZONE_NAMES"         22 rows imported
>. . importing table                    "RHN_UNITS"         35 rows imported
>. . importing table                "RHN_URL_PROBE"          0 rows imported
>. . importing table           "RHN_URL_PROBE_STEP"          0 rows imported
>. . importing table                   "RHN_WIDGET"          3 rows imported
>. . importing table                 "STATE_CHANGE"          7 rows imported
>. . importing table                  "TIME_SERIES"         78 rows imported
>. . importing table              "VALID_COUNTRIES"        240 rows imported
>. . importing table           "VALID_COUNTRIES_TL"        478 rows imported
>. . importing table                  "WEB_CONTACT"          2 rows imported
>. . importing table                 "WEB_CUSTOMER"          2 rows imported
>. . importing table    "WEB_CUSTOMER_NOTIFICATION"          0 rows imported
>. . importing table  "WEB_USER_CONTACT_PERMISSION"          2 rows imported
>. . importing table       "WEB_USER_PERSONAL_INFO"          2 rows imported
>. . importing table              "WEB_USER_PREFIX"          9 rows imported
>. . importing table           "WEB_USER_SITE_INFO"          2 rows imported
>. . importing table           "WEB_USER_SITE_TYPE"          4 rows imported
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHN_CONTACT_MONITORING"                      "
> "  ("RECID","CUSTOMER_ID","CONTACT_LAST_NAME","CONTACT_FIRST_NAME","EMAIL_AD"
> "DRESS","USERNAME","PASSWORD","SCHEDULE_ID","PREFERRED_TIME_ZONE") AS "
> "select	u.id			recid,"
> "	u.org_id		customer_id,"
> "	wupi.last_name		contact_last_name,"
> "	wupi.first_names	contact_first_name,"
> "	rhn_user.find_mailable_address(u.id)"
> "				email_address,"
> "	u.login			username,"
> "	u.password		password,"
> "	1			schedule_id,"
> "	'GMT'			preferred_time_zone"
> "from"
> "	web_user_personal_info wupi,"
> "	web_contact u"
> "where	1=1"
> "	and u.id = wupi.web_user_id"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHN_HOST_MONITORING"                        ("
> ""RECID","IP","NAME","DESCRIPTION","CUSTOMER_ID","OS_ID","ASSET_ID","LAST_UP"
> "DATE_USER","LAST_UPDATE_DATE") AS "
> "select  s.id            recid,"
> "	rhn_server.get_ip_address(s.id)	ip,"
> "        s.name          name,"
> "        s.description   description,"
> "        s.org_id        customer_id,"
> "        '4'             os_id,"
> "        null            asset_id,"
> "        null            last_update_user,"
> "        null            last_update_date"
> "from	rhnServer	s"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNHISTORYVIEW_PACKAGES"                     "
> "   ("EVENT_ID","SERVER_ID","SUMMARY","DETAILS","CREATED","MODIFIED") AS "
> "select"
> "    sa.action_id event_id,"
> "    sa.server_id,"
> "    at.name || ( select ' (' || count(name_id) ||"
> "                        decode(count(name_id), 1, ' package) ',  ' packages"
> ") ')"
> "                 from rhnActionPackage ap where ap.action_id = sa.action_id"
> " ) ||"
> "    ' scheduled by ' || contact.login || ' (' || astat.name || ')' summary,"
> "    'This action will be executed after ' ||"
> "        to_char(a.earliest_action, 'YYYY-MM-DD HH24:MI:SS') || ' EST' || ch"
> "r(10) || chr(10) ||"
> "	'The current action status is: ' || astat.name || chr(10) ||"
> "	nvl2(sa.pickup_time,"
> "	    'The client picked up this action on ' ||"
> "	        to_char(sa.pickup_time, 'YYYY-MM-DD HH24:MI:SS') || ' EST',"
> "	    'This action has not been picked up') || chr(10) ||"
> "	nvl2(sa.completion_time,"
> "	    'The client reported completion on execution on ' ||"
> "	        to_char(sa.completion_time, 'YYYY-MM-DD HH24:MI:SS') || ' EST',"
> "	    'This action has not been fully executed') || chr(10) ||"
> "	nvl2(sa.result_code,"
> "	    'Client execution returned code '||to_char(sa.result_code)||"
> "	        ' ('||nvl(sa.result_msg, 'SUCCESS')||')',"
> "	    '') ||"
> "	chr(10) || chr(10) ||"
> "	'Package list:' || chr(10) || rhnHistoryView_pkglist(sa.action_id) ||"
> "	'' details,"
> "    a.created,"
> "    sa.modified"
> "from"
> "    rhnAction a, rhnServerAction sa,"
> "    rhnActionType at, rhnActionStatus astat,"
> "    web_contact contact"
> "where"
> "    sa.action_id = a.id"
> "and a.action_type = at.id"
> "and a.scheduler = contact.id"
> "and sa.status = astat.id"
> "and at.label in ('packages.update', 'packages.remove')"
> "with"
> "    read only"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNHISTORYVIEW_ERRATA"                       "
> " ("EVENT_ID","SERVER_ID","SUMMARY","DETAILS","CREATED","MODIFIED") AS "
> "select"
> "    sa.action_id event_id,"
> "    sa.server_id,"
> "    at.name || ( select ' (' || count(errata_id) ||"
> "                        decode(count(errata_id), 1, ' erratum) ', ' errata)"
> " ')"
> "                 from rhnActionErrataUpdate aeu where aeu.action_id = sa.ac"
> "tion_id ) ||"
> "    ' scheduled by ' || contact.login || ' (' || astat.name || ')' summary,"
> "    'This action will be executed after ' ||"
> "        to_char(a.earliest_action, 'YYYY-MM-DD HH24:MI:SS') || ' EST' || ch"
> "r(10) || chr(10) ||"
> "	'The current action status is: ' || astat.name || chr(10) ||"
> "	nvl2(sa.pickup_time,"
> "	    'The client picked up this action on ' ||"
> "	        to_char(sa.pickup_time, 'YYYY-MM-DD HH24:MI:SS') || ' EST',"
> "	    'This action has not been picked up') || chr(10) ||"
> "	nvl2(sa.completion_time,"
> "	    'The client reported completion on execution on ' ||"
> "	        to_char(sa.completion_time, 'YYYY-MM-DD HH24:MI:SS') || ' EST',"
> "	    'This action has not been fully executed') || chr(10) ||"
> "	nvl2(sa.result_code,"
> "	    'Client execution returned code '||to_char(sa.result_code)||"
> "	        ' ('||nvl(sa.result_msg, 'SUCCESS')||')',"
> "	    '') ||"
> "	chr(10) || chr(10) ||"
> "	'Errata list:' || chr(10) || rhnHistoryView_erratalist(sa.action_id) ||"
> "	'' details,"
> "    a.created,"
> "    sa.modified"
> "from"
> "    rhnAction a, rhnServerAction sa,"
> "    rhnActionType at, rhnActionStatus astat,"
> "    web_contact contact"
> "where"
> "    sa.action_id = a.id"
> "and a.action_type = at.id"
> "and a.scheduler = contact.id"
> "and sa.status = astat.id"
> "and at.label = 'errata.update'"
> "with"
> "    read only"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNORGPACKAGEOVERVIEW"                       "
> " ("ORG_ID","CHANNEL_ARCH_ID","PACKAGE_ID","PACKAGE_NVREA") AS "
> "select"
> "    p.org_id org_id,"
> "    cpac.channel_arch_id,"
> "    p.id package_id,"
> "    rhn_package.canonical_name(p_name.name, p_evr.evr, pa.name) package_nvr"
> "ea"
> "from"
> "    rhnPackageName p_name,"
> "    rhnPackageEVR p_evr,"
> "    rhnPackageArch pa,"
> "    rhnChannelPackageArchCompat cpac,"
> "    rhnPackage p"
> "where"
> "        p_name.id = p.name_id"
> "    and p_evr.id = p.evr_id"
> "    and cpac.package_arch_id = p.package_arch_id"
> "    and p.package_arch_id = pa.id"
> "order by package_nvrea, p.created"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNHISTORYVIEW"                        ("EVEN"
> "T_ID","SERVER_ID","SUMMARY","DETAILS","CREATED","MODIFIED") AS "
> "select"
> "    id event_id, server_id, summary, details, created, modified"
> "from"
> "    rhnServerHistory"
> "UNION"
> "select "EVENT_ID","SERVER_ID","SUMMARY","DETAILS","CREATED","MODIFIED" from"
> " rhnHistoryView_refresh"
> "UNION"
> "select "EVENT_ID","SERVER_ID","SUMMARY","DETAILS","CREATED","MODIFIED" from"
> " rhnHistoryView_packages"
> "UNION"
> "select "EVENT_ID","SERVER_ID","SUMMARY","DETAILS","CREATED","MODIFIED" from"
> " rhnHistoryView_errata"
> "with"
> "    read only"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNPAIDORGS"                        ("ORG_ID""
> ") AS "
> "select	org_id"
> "from	rhnServerGroup"
> "where	group_type = lookup_sg_type('enterprise_entitled')"
> "	and NVL(max_members,1) > 0"
> "union all"
> "select	sg.org_id"
> "from	rhnServerGroup sg"
> "where	sg.group_type = lookup_sg_type('sw_mgr_entitled')"
> "	and NVL(sg.max_members,1) > 0"
> "    and not exists ("
> "        select 1"
> "        from"
> "            rhnDemoOrgs do"
> "        where"
> "            do.org_id = sg.org_id"
> "            and sg.max_members = 1"
> "    )"
> "union all"
> "select	sg.org_id"
> "from	rhnServerGroup sg"
> "where	group_type = lookup_sg_type('provisioning_entitled')"
> "	and NVL(sg.max_members,2) > 1"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNUSERCHANNEL"                        ("USER"
> "_ID","ORG_ID","CHANNEL_ID","ROLE") AS "
> "select	cfp.user_id		user_id,"
> "	cfp.org_id		org_id,"
> "	cfm.channel_id		channel_id,"
> "	'manage'		role"
> "from	rhnChannelFamilyMembers	cfm,"
> "	rhnUserChannelFamilyPerms cfp"
> "where	cfp.channel_family_id = cfm.channel_family_id"
> "	and rhn_channel.user_role_check(cfm.channel_id,"
> "		cfp.user_id, 'manage') = 1"
> "union all"
> "select	cfp.user_id		user_id,"
> "	cfp.org_id		org_id,"
> "	cfm.channel_id		channel_id,"
> "	'subscribe'		role"
> "from	rhnChannelFamilyMembers	cfm,"
> "	rhnUserChannelFamilyPerms cfp"
> "where	cfp.channel_family_id = cfm.channel_family_id"
> "	and rhn_channel.user_role_check(cfm.channel_id,"
> "		cfp.user_id, 'subscribe') = 1"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNAVAILABLECHANNELS"                        "
> "("ORG_ID","CHANNEL_ID","CHANNEL_DEPTH","CHANNEL_NAME","CHANNEL_ARCH_ID","PA"
> "DDED_NAME","CURRENT_MEMBERS","AVAILABLE_MEMBERS","LAST_MODIFIED","CHANNEL_L"
> "ABEL","PARENT_OR_SELF_LABEL","PARENT_OR_SELF_ID") AS "
> "select"
> "     ct.org_id,"
> "     ct.id,"
> "     CT.depth,"
> "     CT.name,"
> "     CT.channel_arch_id,"
> "     CT.padded_name,"
> "     (SELECT COUNT(1)"
> "        FROM rhnServer S"
> "       WHERE S.org_id = ct.org_id"
> "         AND EXISTS (SELECT 1 FROM rhnServerChannel WHERE channel_id = ct.i"
> "d AND server_id = S.id)),"
> "     rhn_channel.available_chan_subscriptions(ct.id, ct.org_id),"
> "     CT.last_modified,"
> "     CT.label,"
> "     CT.parent_or_self_label,"
> "     CT.parent_or_self_id"
> "from"
> "     rhnOrgChannelTreeView CT"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNUSERAVAILABLECHANNELS"                    "
> "    ("USER_ID","ORG_ID","CHANNEL_ID","CHANNEL_DEPTH","CHANNEL_NAME","CHANNE"
> "L_ARCH_ID","PADDED_NAME","CURRENT_MEMBERS","AVAILABLE_MEMBERS","LAST_MODIFI"
> "ED","CHANNEL_LABEL","PARENT_OR_SELF_LABEL","PARENT_OR_SELF_ID","END_OF_LIFE"
> "") AS "
> "select"
> "     ct.user_id,"
> "     ct.org_id,"
> "     ct.id,"
> "     CT.depth,"
> "     CT.name,"
> "     CT.channel_arch_id,"
> "     CT.padded_name,"
> "     ("
> "     SELECT COUNT(1)"
> "       FROM rhnUserServerPerms USP"
> "      WHERE USP.user_id = ct.user_id"
> "        AND EXISTS (SELECT 1 FROM rhnServerChannel WHERE channel_id = ct.id"
> " AND server_id = USP.server_id)"
> "     ),"
> "     rhn_channel.available_chan_subscriptions(ct.id, ct.org_id),"
> "     CT.last_modified,"
> "     CT.label,"
> "     CT.parent_or_self_label,"
> "     CT.parent_or_self_id,"
> "     CT.end_of_life"
> "from"
> "     rhnUserChannelTreeView ct"
> "where rhn_channel.org_channel_setting(ct.id, ct.org_id ,'not_globally_subsc"
> "ribable') = 0 OR exists ("
> "     						SELECT 1 from rhnChannelPermission per where per.channel_id = ct"
> ".id"
> "     						)"
> "                            OR (rhn_user.check_role(ct.user_id, 'org_admin'"
> ") = 1"
> "                                OR rhn_user.check_role(ct.user_id, 'channel"
> "_admin') = 1)"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNUSERTYPECOMMAVIEW"                        "
> "("USER_ID","IDS","LABELS","NAMES") AS "
> "select"
> "    uta.user_id,"
> "    id_join(', ', uta.type_id_t),"
> "    label_join(', ', uta.type_label_t),"
> "    name_join(', ', uta.type_name_t)"
> "from"
> "    rhnUserTypeArray uta"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNORGERRATA"                        ("ORG_ID"
> "","ERRATA_ID","CHANNEL_ID") AS "
> "select"
> "    ac.org_id,"
> "    ce.errata_id,"
> "    ac.channel_id"
> "from"
> "    rhnChannelErrata ce,"
> "    rhnAvailableChannels ac"
> "where"
> "    ce.channel_id = ac.channel_id"
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "SSALEVAN"."RHNUSERSINORGOVERVIEW"                       "
> " ("ORG_ID","USER_ID","USER_LOGIN","USER_FIRST_NAME","USER_LAST_NAME","USER_"
> "MODIFIED","SERVER_COUNT","SERVER_GROUP_COUNT","ROLE_NAMES") AS "
> "select"
> "	u.org_id					org_id,"
> "	u.id						user_id,"
> "	u.login						user_login,"
> "	pi.first_names					user_first_name,"
> "	pi.last_name					user_last_name,"
> "	u.modified					user_modified,"
> "    	(	select	count(server_id)"
> "		from	rhnUserServerPerms sp"
> "		where	sp.user_id = u.id)"
> "							server_count,"
> "	(	select	count(server_group_id)"
> "		from	rhnUserManagedServerGroups umsg"
> "		where	umsg.user_id = u.id and exists ("
> "			select	1"
> "			from	rhnVisibleServerGroup sg"
> "			where	sg.id = umsg.server_group_id))"
> "							server_group_count,"
> "	(	select	nvl(utcv.names, '(normal user)')"
> "		from	rhnUserTypeCommaView utcv"
> "		where	utcv.user_id = u.id)"
> "							role_names"
> "from	web_user_personal_info pi,"
> "	web_contact u"
> "where"
> "	u.id = pi.web_user_id"
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNCRYPTOKEYKICKSTART" ADD CONSTRAINT "RHN_CKEY_KS_CKID_FK" FO"
> "REIGN KEY ("CRYPTO_KEY_ID") REFERENCES "RHNCRYPTOKEY" ("ID") ON DELETE CASC"
> "ADE ENABLE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNCRYPTOKEYKICKSTART" ADD CONSTRAINT "RHN_CKEY_KS_KSD_FK" FOR"
> "EIGN KEY ("KSDATA_ID") REFERENCES "RHNKSDATA" ("ID") ON DELETE CASCADE ENAB"
> "LE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNCONFIGREVISION" ADD CONSTRAINT "RHN_CONFREVISION_CCID_FK" F"
> "OREIGN KEY ("CONFIG_CONTENT_ID") REFERENCES "RHNCONFIGCONTENT" ("ID") ENABL"
> "E NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNKICKSTARTCOMMAND" ADD CONSTRAINT "RHN_KSCOMMAND_KSID_FK" FO"
> "REIGN KEY ("KICKSTART_ID") REFERENCES "RHNKSDATA" ("ID") ON DELETE CASCADE "
> "ENABLE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNKICKSTARTDEFAULTREGTOKEN" ADD CONSTRAINT "RHN_KSDRT_KSID_FK"
> "" FOREIGN KEY ("KICKSTART_ID") REFERENCES "RHNKSDATA" ("ID") ON DELETE CASC"
> "ADE ENABLE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNKICKSTARTDEFAULTS" ADD CONSTRAINT "RHN_KSD_KSID_FK" FOREIGN"
> " KEY ("KICKSTART_ID") REFERENCES "RHNKSDATA" ("ID") ON DELETE CASCADE ENABL"
> "E NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNKICKSTARTIPRANGE" ADD CONSTRAINT "RHN_KSIP_KSID_FK" FOREIGN"
> " KEY ("KICKSTART_ID") REFERENCES "RHNKSDATA" ("ID") ON DELETE CASCADE ENABL"
> "E NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNKICKSTARTPACKAGE" ADD CONSTRAINT "RHN_KSPACKAGE_KSID_FK" FO"
> "REIGN KEY ("KICKSTART_ID") REFERENCES "RHNKSDATA" ("ID") ON DELETE CASCADE "
> "ENABLE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNKICKSTARTPRESERVEFILELIST" ADD CONSTRAINT "RHN_KSPRESERVEFL"
> "_KSID_FK" FOREIGN KEY ("KICKSTART_ID") REFERENCES "RHNKSDATA" ("ID") ON DEL"
> "ETE CASCADE ENABLE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNKICKSTARTCHILDCHANNEL" ADD CONSTRAINT "RHN_KS_CC_KSD_FK" FO"
> "REIGN KEY ("KSDATA_ID") REFERENCES "RHNKSDATA" ("ID") ON DELETE CASCADE ENA"
> "BLE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNKICKSTARTSESSION" ADD CONSTRAINT "RHN_KS_SESSION_KSID_FK" F"
> "OREIGN KEY ("KICKSTART_ID") REFERENCES "RHNKSDATA" ("ID") ON DELETE CASCADE"
> " ENABLE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00017: following statement failed with ORACLE error 942:
> "ALTER TABLE "RHNSATELLITESERVERGROUP" ADD CONSTRAINT "RHN_SATSG_SID_FK" FOR"
> "EIGN KEY ("SERVER_ID") REFERENCES "RHNSATELLITEINFO" ("SERVER_ID") ON DELET"
> "E CASCADE ENABLE NOVALIDATE"
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00041: Warning: object created with compilation warnings
> "CREATE TRIGGER "SSALEVAN".rhn_confrevision_acct_trig"
> "after insert on rhnConfigRevision"
> "for each row"
> "declare"
> "	org_id number;"
> "	available number;"
> "	added number;"
> "begin"
> "	select	cc.org_id id,"
> "			oq.total + oq.bonus - oq.used available,"
> "			content.file_size added"
> "	into	org_id, available, added"
> "	from	rhnConfigContent	content,"
> "			rhnOrgQuota			oq,"
> "			rhnConfigChannel	cc,"
> "			rhnConfigFile		cf"
> "	where	cf.id = :new.config_file_id"
> "			and cf.config_channel_id = cc.id"
> "			and cc.org_id = oq.org_id"
> "			and :new.config_content_id = content.id;"
> "	if added > available then"
> "		rhn_exception.raise_exception('not_enough_quota');"
> "	end if;"
> "end;"
>About to enable constraints...
>Import terminated successfully with warnings.
>

Actions: View

Attachments on bug 464927: 318600 | 318601 | 318603 | 319056