Current Position:Home > BC4J Temporary Tables

BC4J Temporary Tables

Update:11-30Source: network consolidation
Advertisement
Is there any way to customize the way bc4j creates its temporary tables? Specifically, I would like to change how this one is created. Right now it is:CREATE TABLE "PS_WebsiteService_10"
  ID        NUMBER(20),
  PARENTID  NUMBER(20),
  COLLID    NUMBER(10),
  CONTENT   BLOB,
  KEYCONT   BLOB
LOGGING
NOCACHE
NOPARALLEL;
CREATE UNIQUE INDEX PS_WEBSITESERVICE_10_PK ON "PS_WebsiteService_10"
(COLLID, ID)
LOGGING
NOPARALLEL;
ALTER TABLE "PS_WebsiteService_10" ADD (
  CONSTRAINT PS_WEBSITESERVICE_10_PK PRIMARY KEY (COLLID, ID));My DBAs would like to put NOLOGGING in there. Apparently there are some insane logs going on in the database. Something to do with a BLOB bug in the db version we have they tell me.

The Best Answer

Advertisement
Hi Steve/Nick,
I am facing a similar kind of problem in oracle 9iAS(90220). A few days back there was a lot of user activity in one of the application modules and 7 PS_<app.module.name(s)> tables were created with around 7GB of size which eventually filled up the entire tablespace(100%). I spoke to the developers about the attributes that need to be set for Row spill over feature discussed in this forum but they said after lots of testing they have set those values and cannot be changed.
Could you please suggest me how can I ensure that, next time any application module specific PS_ tables will get created I can route them to different tablespace based on the module name. (I donot want to move them after they are created, to a different tablespace) Please let me know asap so that I can implement it and avert any future problems.
Thanks & regards,
Ramana
  • BC4J temporary tables - default tablespace Update:11-30

    I have database Oracle database 9i. I have created database user by CREATE USER "DBUSER" PROFILE "DEFAULT" IDENTIFIED BY "dbuser" DEFAULT TABLESPACE "MYTABLESPACE" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOC

  • BC4J Temporary Tables Update:11-30

    Is there any way to customize the way bc4j creates its temporary tables? Specifically, I would like to change how this one is created. Right now it is:CREATE TABLE "PS_WebsiteService_10"   ID        NUMBER(20),   PARENTID  NUMBER(20),   COLLID  

  • BC temporary table Update:11-30

    Hello, i'd like to know more about the temporary tables used by BC4J. I've read this very old article => http://www.oracle.com/technology/products/jdev/htdocs/bc4j/bc4j_temp_tables.html but i still miss some information I'd like to know what is the b

  • Temporary table within a package Update:10-11

    I'm not sure this is the best way to achieve it, but I'm trying to use a temporary table within my package, but I failed! In my package, my procedure do receive 5 different phone numbers (vTel1 to vTel5) and I need to order them, using data from a ta

  • How create temporary table from list of values Update:10-11

    Can you anybody advise me how can I create temporary table from list of values? I have list of values and need create temporary table for next use with command JOIN etc. Thank you for helpNO, you can not create temporary table in oracle on the fly (

  • Can I get Date also from temporary table? Update:10-11

    --(1) get table ONLY create global temporary table cat1 as select * from category; --(2) get table and data create table cat2 as select * from category; nullUse IndexRead other 2 answers

  • Report: sorting of data and temporary table sorting Update:10-11

    We have a report that runs a procedure, which inserts data into a temporary table using the supplied parameters. The report then selects data from this table. Previously the report has always displayed data in the same order in which it was inserted

  • Use of global temporary tables in Procedures Update:10-11

    Hi I am using global temporary tables in the procedures. Loading data in the same table through many procedures. I am fetching the data from the global temporary table in PRO-C by a cursor. Will this degrade performance? Please help me.. Thanks in Ad

  • How to Use Temporary table on report builder Update:10-11

    Hi community! Well, i'm trying to build a temporary table based report in Oracle Report Builder. in "After Parameter Form Trigger" I've placed a stored procedure that populate a temporary table and I've based my report on it. The problem is Repo

  • How to Create a Temporary Table with SQL Server Update:10-11

    I know you can create a temporary table in SQL Server 2000, but not quite sure how to do it in CFMX 7, i.e., does the SQL go inside a <CFQUERY dbtype="query"> tag? I'm pulling the main set of records from an Oracle server (1st data source)