891:
892: v_sql_stmt:=
893: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
894:
895: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
896: application_short_name => p_schema,
897: statement_type => AD_DDL.CREATE_TABLE,
898: statement => v_sql_stmt,
899: object_name => p_table);
893: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
894:
895: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
896: application_short_name => p_schema,
897: statement_type => AD_DDL.CREATE_TABLE,
898: statement => v_sql_stmt,
899: object_name => p_table);
900:
901: EXCEPTION
933: lv_retval := FND_INSTALLATION.GET_APP_INFO(
934: 'FND', lv_dummy1,lv_dummy2, v_applsys_schema);
935:
936: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(523);
937: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
938: application_short_name => lv_prod_short_name,
939: statement_type => AD_DDL.CREATE_INDEX,
940: statement => p_sql_stmt,
941: object_name => p_object);
935:
936: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(523);
937: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
938: application_short_name => lv_prod_short_name,
939: statement_type => AD_DDL.CREATE_INDEX,
940: statement => p_sql_stmt,
941: object_name => p_object);
942:
943: