Here you go. I exported the relevant table and view definitions. The entire
schema is huge (171 tables and +20 views) so I guess it doesn't make sense to
export that.
Hope this helps,
Best regards,
Robert
> >
> > That looks like a bug to me. Do you need all table and view
> > definitions to
> > investigate further?
>
> It would make things easier and would help in our situation
> being some people on holiday and the working stack of the
> remaining increasing.
>
> Thank you
>
> Elke
> SAP Labs Berlin
>
> > This happens on 7.3 and 7.4 (7.4.3 build 017-123-039-277).
> >
> > Regards,
> >
> > Robert
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > _______________________________________________
> > sapdb.general mailing list
> > [EMAIL PROTECTED]
> > http://listserv.sap.com/mailman/listinfo/sapdb.general
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
CREATE TABLE "INFONET3_RK"."ATHLETE"
(
"ATH_ID" Varchar (32) ASCII,
"ATH_CREATED" Timestamp,
"ATH_CONFIRMED_AT" Timestamp,
"ATH_LASTMODIFIED" Timestamp,
"ATH_FIRSTNAME" Varchar (100) ASCII,
"ATH_LASTNAME" Varchar (100) ASCII,
"ATH_NICKNAME" Varchar (100) ASCII,
"ATH_ADR_ID" Varchar (32) ASCII,
"ATH_PER_ID" Varchar (32) ASCII,
"ATH_BELONGTO_CTR_I" Char (4) ASCII,
"ATH_NATIONALITY" Char (4) ASCII,
"ATH_DATEOFBIRTH" Date,
"ATH_DSC_ID" Varchar (32) ASCII,
"ATH_DSC_DESCRIPTIO" Varchar (240) ASCII,
"ATH_SEA_ID" Varchar (32) ASCII,
"ATH_ATX_PROFESSION" Varchar (100) ASCII,
"ATH_ATX_FAVORITEMU" Varchar (32) ASCII,
"ATH_ATX_FAVORITEFO" Varchar (32) ASCII,
"ATH_ATX_HOBBIES" Varchar (32) ASCII,
"ATH_ATX_PHILOSOPHY" Varchar (32) ASCII,
"ATH_ATX_RESUME" Varchar (32) ASCII,
"ATH_ATX_ACHIEVEMEN" Varchar (32) ASCII,
"ATH_ATX_SHORTSTATE" Varchar (32) ASCII,
"ATH_ATX_RBUSAGE" Varchar (32) ASCII,
"ATH_ATX_RBNOTES" Varchar (32) ASCII,
"ATH_ATX_TEXT_10" Varchar (32) ASCII,
"ATH_ATX_TEXT_11" Varchar (32) ASCII,
"ATH_ATX_TEXT_12" Varchar (32) ASCII,
"ATH_ATX_OTHERSPONS" Varchar (32) ASCII,
"ATH_CLOTHINGSIZE" Varchar (30) ASCII,
"ATH_HEIGHT" Varchar (30) ASCII,
"ATH_WEIGHT" Varchar (30) ASCII,
"ATH_HELMETSIZE" Varchar (30) ASCII,
"ATH_COLOURHAIR" Varchar (30) ASCII,
"ATH_COLOUREYES" Varchar (30) ASCII,
"ATH_RBCONTACT_ID" Varchar (32) ASCII,
"ATH_TYPE_OF_SPONSO" Integer,
"ATH_SPONSORED_SINC" Date,
"ATH_VIS_INFONET" Boolean,
"ATH_VIS_LOCAL" Boolean,
"ATH_VIS_LOCAL_N" Boolean,
"ATH_VIS_LOCAL_S" Boolean,
"ATH_VIS_DOTCOM" Boolean,
"ATH_VIS_PHOTOFILES" Boolean,
"ATH_PF_ONLY" Boolean,
"ATH_PF_LIST_IN_SI" Boolean,
"ATH_STATUS" Integer,
"ATH_MOD_FIELDS" Varchar (240) ASCII,
"ATH_RBCPORT_MOB_ID" Varchar (32) ASCII,
PRIMARY KEY ("ATH_ID"),
FOREIGN KEY "C1_ATHLETE" ("ATH_DSC_ID") REFERENCES
"INFONET3_RK"."DISCIPLINE" ("DSC_ID") ON DELETE RESTRICT,
FOREIGN KEY "C2_ATHLETE" ("ATH_ATX_FAVORITEMU") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C3_ATHLETE" ("ATH_ATX_FAVORITEFO") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C4_ATHLETE" ("ATH_ATX_HOBBIES") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C5_ATHLETE" ("ATH_ATX_PHILOSOPHY") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C6_ATHLETE" ("ATH_ATX_RESUME") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C7_ATHLETE" ("ATH_ATX_ACHIEVEMEN") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C8_ATHLETE" ("ATH_ATX_SHORTSTATE") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C9_ATHLETE" ("ATH_ATX_RBUSAGE") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C10_ATHLETE" ("ATH_ATX_RBNOTES") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C11_ATHLETE" ("ATH_ATX_TEXT_10") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C12_ATHLETE" ("ATH_ATX_TEXT_11") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C13_ATHLETE" ("ATH_ATX_TEXT_12") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C14_ATHLETE" ("ATH_ATX_OTHERSPONS") REFERENCES
"INFONET3_RK"."ATHLETES_TEXT" ("ATX_ID") ON DELETE RESTRICT,
FOREIGN KEY "C15_ATHLETE" ("ATH_ADR_ID") REFERENCES
"INFONET3_RK"."ADDRESS" ("ADR_ID") ON DELETE RESTRICT,
FOREIGN KEY "C16_ATHLETE" ("ATH_PER_ID") REFERENCES
"INFONET3_RK"."PERSON" ("PER_ID") ON DELETE RESTRICT,
FOREIGN KEY "C17_ATHLETE" ("ATH_BELONGTO_CTR_I") REFERENCES
"INFONET3_RK"."COUNTRY" ("CTR_ISO") ON DELETE RESTRICT,
FOREIGN KEY "C18_ATHLETE" ("ATH_NATIONALITY") REFERENCES
"INFONET3_RK"."COUNTRY" ("CTR_ISO") ON DELETE RESTRICT,
FOREIGN KEY "C19_ATHLETE" ("ATH_RBCONTACT_ID") REFERENCES
"INFONET3_RK"."PERSON" ("PER_ID") ON DELETE RESTRICT,
FOREIGN KEY "C20_ATHLETE" ("ATH_RBCPORT_MOB_ID") REFERENCES
"INFONET3_RK"."MIME_OBJECT" ("MOB_ID") ON DELETE RESTRICT
)
CREATE TABLE "INFONET3_RK"."COUNTRY"
(
"CTR_ISO" Char (4) ASCII,
"CTR_QBK_PER_ID" Varchar (32) ASCII,
"CTR_CGR_ID" Varchar (32) ASCII,
"CTR_NAME" Varchar (100) ASCII,
"CTR_OWN_NAME" Varchar (100) ASCII,
"CTR_SHORT_NAME" Varchar (50) ASCII,
"CTR_IS_RB_COUNTRY" Boolean,
"CTR_ADR_ID" Varchar (32) ASCII,
"CTR_LP_EMAIL" Varchar (254) ASCII,
"CTR_EXT_LISTED" Boolean,
"CTR_INT_LISTED" Boolean,
"CTR_HAS_ONP_CAL" Boolean,
PRIMARY KEY ("CTR_ISO"),
FOREIGN KEY "C1_COUNTRY" ("CTR_CGR_ID") REFERENCES
"INFONET3_RK"."COUNTRY_GROUP" ("CGR_ID") ON DELETE RESTRICT,
FOREIGN KEY "C2_COUNTRY" ("CTR_QBK_PER_ID") REFERENCES
"INFONET3_RK"."PERSON" ("PER_ID") ON DELETE RESTRICT,
FOREIGN KEY "C3_COUNTRY" ("CTR_ADR_ID") REFERENCES
"INFONET3_RK"."ADDRESS" ("ADR_ID") ON DELETE RESTRICT
)
CREATE TABLE "INFONET3_RK"."DISCIPLINE"
(
"DSC_ID" Varchar (32) ASCII,
"DSC_NAME" Varchar (240) ASCII,
"DSC_DESCRIPTION" Varchar (240) ASCII,
"DSC_CTG_ID" Varchar (32) ASCII,
"DSC_ABBREVIATION" Char (10) ASCII,
PRIMARY KEY ("DSC_ID"),
FOREIGN KEY "C1_DISCIPLINE" ("DSC_CTG_ID") REFERENCES
"INFONET3_RK"."CATEGORY" ("CTG_ID") ON DELETE RESTRICT
)
CREATE TABLE "INFONET3_RK"."ADDRESS"
(
"ADR_ID" Varchar (32) ASCII,
"ADR_DESCRIPTION" Varchar (254) ASCII,
"ADR_STREET" Varchar (150) ASCII,
"ADR_ZIP" Varchar (20) ASCII,
"ADR_CITY" Varchar (100) ASCII,
"ADR_CTR_ISO" Char (4) ASCII,
"ADR_PHONE" Varchar (50) ASCII,
"ADR_MOBILE" Varchar (50) ASCII,
"ADR_FAX" Varchar (50) ASCII,
"ADR_EMAIL" Varchar (240) ASCII,
"ADR_WWW" Varchar (240) ASCII,
"ADR_COMPANY" Varchar (240) ASCII,
PRIMARY KEY ("ADR_ID"),
FOREIGN KEY "C1_ADDRESS" ("ADR_CTR_ISO") REFERENCES
"INFONET3_RK"."COUNTRY" ("CTR_ISO") ON DELETE RESTRICT
)
CREATE VIEW "V_ATHLETE_INFO"
(
"ATH_ID",
"ATH_FIRSTNAME",
"ATH_LASTNAME",
"ATH_BELONGTO_CTR_I",
"ATH_NATIONALITY",
"ATH_ADR_ID",
"ATH_STATUS",
"ATH_DSC_ID",
"ATH_DSC_DESCRIPTIO",
"ATH_PF_ONLY",
"ATH_TYPE_OF_SPONSO",
"ATH_SPONSORED_SINC",
"ATH_PF_LIST_IN_SI",
"ATH_LASTMODIFIED",
"ATH_CONFIRMED_AT",
"ATH_VIS_LOCAL",
"ATH_VIS_LOCAL_N",
"ATH_VIS_LOCAL_S",
"ATH_VIS_DOTCOM",
"ATH_VIS_PHOTOFILES",
"ATH_CREATED",
"COUNTRY",
"NATIONALITY_NAME",
"DSC_NAME",
"DSC_CTG_ID"
)
AS SELECT ATH_ID, ATH_FIRSTNAME, ATH_LASTNAME, ATH_BELONGTO_CTR_I, ATH_NATIONALITY,
ATH_ADR_ID, ATH_STATUS, ATH_DSC_ID, ATH_DSC_DESCRIPTIO, ATH_PF_ONLY,
ATH_TYPE_OF_SPONSO, ATH_SPONSORED_SINC, ATH_PF_LIST_IN_SI, ATH_LASTMODIFIED,
ATH_CONFIRMED_AT, ATH_VIS_LOCAL, ATH_VIS_LOCAL_N, ATH_VIS_LOCAL_S, ATH_VIS_DOTCOM,
ATH_VIS_PHOTOFILES, ATH_CREATED, COUNTRY.CTR_SHORT_NAME COUNTRY,
NATIONALITY.CTR_SHORT_NAME NATIONALITY_NAME, DSC_NAME, DSC_CTG_ID FROM ATHLETE,
COUNTRY, COUNTRY NATIONALITY, DISCIPLINE WHERE ATH_DSC_ID = DSC_ID (+) AND
ATH_BELONGTO_CTR_I = COUNTRY.CTR_ISO (+) AND ATH_NATIONALITY = NATIONALITY.CTR_ISO (+)
