²EXPORT:V09.02.00 ULPORTAL RUSERS 2048 0 20 0 ²ig Wed Apr 9 10:35:23 2008lportal.dmpd`$     #G###A°#ƒigd`$     #G###A°#ƒ²²-08:00BYTE INTERPRETED PROCACTION ýÿBEGIN msys.dbms_logrep_imp.instantiate_schema(schema_name=>'LPORTAL', export_db_name=>'ORCL', inst_scn=>'4486584'); COMMIT; END; TABLE "ACCOUNT_" CREATE TABLE "ACCOUNT_" ("ACCOUNTID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "PARENTACCOUNTID" NUMBER(30, 0), "NAME" VARCHAR2(75), "LEGALNAME" VARCHAR2(75), "LEGALID" VARCHAR2(75), "LEGALTYPE" VARCHAR2(75), "SICCODE" VARCHAR2(75), "TICKERSYMBOL" VARCHAR2(75), "INDUSTRY" VARCHAR2(75), "TYPE_" VARCHAR2(75), "SIZE_" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "ACCOUNT_" ("ACCOUNTID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "PARENTACCOUNTID", "NAME", "LEGALNAME", "LEGALID", "LEGALTYPE", "SICCODE", "TICKERSYMBOL", "INDUSTRY", "TYPE_", "SIZE_") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) Ki´ ´ KiKiKiKiKiKiKiKiKiÁÁÁþÿxl #0xl #0€Liferay Liferay, Inc.þÿþÿþÿþÿþÿþÿþÿÿÿ ALTER TABLE "ACCOUNT_" ADD PRIMARY KEY ("ACCOUNTID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ENABLE TABLE "ADDRESS" CREATE TABLE "ADDRESS" ("ADDRESSID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "CLASSNAMEID" NUMBER(30, 0), "CLASSPK" NUMBER(30, 0), "STREET1" VARCHAR2(75), "STREET2" VARCHAR2(75), "STREET3" VARCHAR2(75), "CITY" VARCHAR2(75), "ZIP" VARCHAR2(75), "REGIONID" NUMBER(30, 0), "COUNTRYID" NUMBER(30, 0), "TYPEID" NUMBER(30, 0), "MAILING" NUMBER(1, 0), "PRIMARY_" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "ADDRESS" ("ADDRESSID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "CLASSNAMEID", "CLASSPK", "STREET1", "STREET2", "STREET3", "CITY", "ZIP", "REGIONID", "COUNTRYID", "TYPEID", "MAILING", "PRIMARY_") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18) Ki´ ´ KiKiKiKiKiÿÿ CREATE INDEX "IX_93D5AD4E" ON "ADDRESS" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_ABD7DAC0" ON "ADDRESS" ("COMPANYID" , "CLASSNAMEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_71CB1123" ON "ADDRESS" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_923BD178" ON "ADDRESS" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" , "MAILING" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_9226DBB4" ON "ADDRESS" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" , "PRIMARY_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_5BC8B0D4" ON "ADDRESS" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ALTER TABLE "ADDRESS" ADD PRIMARY KEY ("ADDRESSID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ENABLE TABLE "ANNOUNCEMENTSDELIVERY" CREATE TABLE "ANNOUNCEMENTSDELIVERY" ("DELIVERYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "TYPE_" VARCHAR2(75), "EMAIL" NUMBER(1, 0), "SMS" NUMBER(1, 0), "WEBSITE" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "ANNOUNCEMENTSDELIVERY" ("DELIVERYID", "COMPANYID", "USERID", "TYPE_", "EMAIL", "SMS", "WEBSITE") VALUES (:1, :2, :3, :4, :5, :6, :7) Kiÿÿ CREATE INDEX "IX_6EDB9600" ON "ANNOUNCEMENTSDELIVERY" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_BA4413D5" ON "ANNOUNCEMENTSDELIVERY" ("USERID" , "TYPE_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ALTER TABLE "ANNOUNCEMENTSDELIVERY" ADD PRIMARY KEY ("DELIVERYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ENABLE TABLE "ANNOUNCEMENTSENTRY" CREATE TABLE "ANNOUNCEMENTSENTRY" ("UUID_" VARCHAR2(75), "ENTRYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "CLASSNAMEID" NUMBER(30, 0), "CLASSPK" NUMBER(30, 0), "TITLE" VARCHAR2(75), "CONTENT" VARCHAR2(4000), "URL" VARCHAR2(4000), "TYPE_" VARCHAR2(75), "DISPLAYDATE" TIMESTAMP (6), "EXPIRATIONDATE" TIMESTAMP (6), "PRIORITY" NUMBER(30, 0), "ALERT" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "ANNOUNCEMENTSENTRY" ("UUID_", "ENTRYID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "CLASSNAMEID", "CLASSPK", "TITLE", "CONTENT", "URL", "TYPE_", "DISPLAYDATE", "EXPIRATIONDATE", "PRIORITY", "ALERT") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17) KiKi´ ´ Ki i iKi´ ´ ÿÿ CREATE INDEX "IX_A6EF0B81" ON "ANNOUNCEMENTSENTRY" ("CLASSNAMEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_14F06A6B" ON "ANNOUNCEMENTSENTRY" ("CLASSNAMEID" , "CLASSPK" , "ALERT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_D49C2E66" ON "ANNOUNCEMENTSENTRY" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_1AFBDE08" ON "ANNOUNCEMENTSENTRY" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ALTER TABLE "ANNOUNCEMENTSENTRY" ADD PRIMARY KEY ("ENTRYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ENABLE TABLE "ANNOUNCEMENTSFLAG" CREATE TABLE "ANNOUNCEMENTSFLAG" ("FLAGID" NUMBER(30, 0) NOT NULL ENABLE, "USERID" NUMBER(30, 0), "CREATEDATE" TIMESTAMP (6), "ENTRYID" NUMBER(30, 0), "VALUE" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "ANNOUNCEMENTSFLAG" ("FLAGID", "USERID", "CREATEDATE", "ENTRYID", "VALUE") VALUES (:1, :2, :3, :4, :5) ´ ÿÿ CREATE INDEX "IX_9C7EB9F" ON "ANNOUNCEMENTSFLAG" ("ENTRYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_4539A99C" ON "ANNOUNCEMENTSFLAG" ("USERID" , "ENTRYID" , "VALUE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ALTER TABLE "ANNOUNCEMENTSFLAG" ADD PRIMARY KEY ("FLAGID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ENABLE TABLE "BLOGSCATEGORY" CREATE TABLE "BLOGSCATEGORY" ("CATEGORYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "PARENTCATEGORYID" NUMBER(30, 0), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "BLOGSCATEGORY" ("CATEGORYID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "PARENTCATEGORYID", "NAME", "DESCRIPTION") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9) Ki´ ´ Ki iÿÿ ALTER TABLE "BLOGSCATEGORY" ADD PRIMARY KEY ("CATEGORYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ENABLE TABLE "BLOGSENTRY" CREATE TABLE "BLOGSENTRY" ("UUID_" VARCHAR2(75), "ENTRYID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "TITLE" VARCHAR2(150), "URLTITLE" VARCHAR2(150), "CONTENT" CLOB, "DISPLAYDATE" TIMESTAMP (6)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("CONTENT") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)) INSERT INTO "BLOGSENTRY" ("UUID_", "ENTRYID", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "TITLE", "URLTITLE", "CONTENT", "DISPLAYDATE") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) KiKi´ ´ –i–ipi´ CONTENTÿÿ CREATE INDEX "IX_72EF6041" ON "BLOGSENTRY" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_8CACE77B" ON "BLOGSENTRY" ("COMPANYID" , "USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_81A50303" ON "BLOGSENTRY" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_DB780A20" ON "BLOGSENTRY" ("GROUPID" , "URLTITLE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_C07CA83D" ON "BLOGSENTRY" ("GROUPID" , "USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_69157A4D" ON "BLOGSENTRY" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_1B1040FD" ON "BLOGSENTRY" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ALTER TABLE "BLOGSENTRY" ADD PRIMARY KEY ("ENTRYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ENABLE TABLE "BLOGSSTATSUSER" CREATE TABLE "BLOGSSTATSUSER" ("STATSUSERID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "ENTRYCOUNT" NUMBER(30, 0), "LASTPOSTDATE" TIMESTAMP (6), "RATINGSTOTALENTRIES" NUMBER(30, 0), "RATINGSTOTALSCORE" NUMBER(30, 20), "RATINGSAVERAGESCORE" NUMBER(30, 20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "BLOGSSTATSUSER" ("STATSUSERID", "GROUPID", "COMPANYID", "USERID", "ENTRYCOUNT", "LASTPOSTDATE", "RATINGSTOTALENTRIES", "RATINGSTOTALSCORE", "RATINGSAVERAGESCORE") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9) ´ ÿÿ CREATE INDEX "IX_90CDA39A" ON "BLOGSSTATSUSER" ("COMPANYID" , "ENTRYCOUNT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_43840EEB" ON "BLOGSSTATSUSER" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_28C78D5C" ON "BLOGSSTATSUSER" ("GROUPID" , "ENTRYCOUNT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_82254C25" ON "BLOGSSTATSUSER" ("GROUPID" , "USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING CREATE INDEX "IX_BB51F1D9" ON "BLOGSSTATSUSER" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ALTER TABLE "BLOGSSTATSUSER" ADD PRIMARY KEY ("STATSUSERID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING ENABLE TABLE "BOOKMARKSENTRY" CREATE TABLE "BOOKMARKSENTRY" ("UUID_" VARCHAR2(75), "ENTRYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "FOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(300), "URL" VARCHAR2(4000), "COMMENTS" VARCHAR2(4000), "VISITS" NUMBER(30, 0), "PRIORITY" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "BOOKMARKSENTRY" ("UUID_", "ENTRYID", "COMPANYID", "USERID", "CREATEDATE", "MODIFIEDDATE", "FOLDERID", "NAME", "URL", "COMMENTS", "VISITS", "PRIORITY") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) Ki´ ´ bundles/glassfish-3.1.2.2/bin" />