3 Replies Latest reply: Aug 3, 2012 6:34 AM by JorgeB-Oracle RSS

    dropping table

    923096
      Hi,

      I want drop table family_rdf_data from example using drop table family_rdf_data, but I get error Cannot drop table "FAMILY_RDF_DATA" because this table owns RDF objects. So how drop this table?
        • 1. Re: dropping table
          JorgeB-Oracle
          Solution:

          1. Drop the entailment first if it exists:

          EXECUTE SEM_APIS.DROP_ENTAILMENT ('rdfs_rix_family');


          2. Drop the model:

          execute SEM_APIS.drop_sem_model('family');

          3. Then drop the table:

          drop table family_rdf_data;

          Regards!
          Jorge
          • 2. Re: dropping table
            923096
            Thanks, it works. I have one more problem : when I try do
            BEGIN
            SEM_APIS.CREATE_ENTAILMENT(
            *'rdfs_rix_family',*
            SEM_Models('family'),
            SEM_Rulebases('RDFS','family_rb'));
            END;
            I get error
            Error report:
            ORA-20000: Cannot proceed without USER_RULES=T option when there is at least one user defined rule in one of the rulebases
            ORA-06512: przy "MDSYS.SDO_SEM_INFERENCE", linia 11209
            ORA-06512: przy "MDSYS.RDF_APIS", linia 72
            ORA-06512: przy linia 2
            *20000. 00000 - "%s"*
            **Cause: The stored procedure 'raise_application_error'*
            was called which causes this error to be generated.
            **Action: Correct the problem as described in the error message or contact*
            the application administrator or DBA for more information.
            • 3. Re: dropping table
              JorgeB-Oracle
              Hi,

              When a rule base other than the standard is used we must use USER_RULES=T

              Try the following:

              exec SEM_APIS.DROP_ENTAILMENT('rdfs_rix_family');

              BEGIN
              SEM_APIS.CREATE_ENTAILMENT(
              'rdfs_rix_family',
              SEM_Models('family'),
              SEM_Rulebases('RDFS','family_rb'),
              SEM_APIS.REACH_CLOSURE, null, 'USER_RULES=T');
              END;
              /

              Regards!
              Jorge