Search results for query: *

I hope I understand your question. I think the initial value would be 40K as specified in the DEFAULT STORAGE attribute of the CREATE TABLESPACE statement.

In previous versions (Ora 8, 9) I used a CREATE TABLESPACE command numerous times to make our project accounts. The whole command is as follows: CREATE TABLESPACE myTablespace_TS DATAFILE 'c:\oracle\oradata\myTablespace_TS.dbf' SIZE 50M DEFAULT STORAGE (INITIAL 20K NEXT 20K MAXEXTENTS 249...

Is it possible to delete a table by identifying the tablespace, owner, and table name? We have several accounts set up. Most of them have tables with the same name. Can I drop a table by identifying which tablespace it is in before identifying which account owns the table? Maybe I am way off...

Mufasa, I realized today that I never responded to you. Sorry about that. I tried your approach and it works great. We are able to move our tables into the correct tablespace now. You were a great help. Thanks, Fran

Has anyone ever tried to edit the DMP file produced by the Oracle EXP utility? I noticed that the dump file contains the name of the tablespace of the original set of tables. Oracle will IMP the tables into the same tablespace name on the new server. If I want to IMP into another server...

We are having a problem when ColdFusion replaces two variables inside a CFMAIL tag. If there is no normal text between two variable substitutions, ColdFusion drops the carriage return line feeds that format the text into paragraphs. I have attached source code which has three examples in it...

I read the Ben Forta information in chapter 21 of the CFMX WACK. It discusses uploading multiple files and displaying a message between each file using the CFFLUSH tag. It does not discuss a single large file that takes a long time to upload. Is there some way to determine the status of an...

Ok guys, four years have gone by. Surely some one has devised a way to do this by now. Maybe ColdFusion has a new capability with the CFMX or CF50. How do we go about displaying an upload status bar for a CFFILE upload?

I have a similar problem with a scheduled task that is supposed to do nightly Source Code backups. The task ran for about 4 years and then it got intermittent (wouldn't run every night). Eventually, it rarely ran. As an experiment I disabled the other scheduled tasks and it has run...

Is anyone familiar with restrictions/imcompatibilites between versions of ColdFusion's Verity Collections and Adobe Acrobat PDF files? Our environment: we are running CF5.0 and the group of PDF files seems to range from version 1.2-1.4 in our subDirectory of uploaded files. We are having...

I went back to the Operating System and made the ODBC specification again. This time it worked. Must have been a cockpit error the first time. Thanks anyway. Fran

Earlier today, I installed an evaluation copy of MS SQL 2000. After the installation completed, I copied two old database files from MS SQL 7. To get MSL2000 to register the database, I ran the sp_attach_db stored procedure. After which I ran the sp_updatestats stored procedure as they...

My apologies guys. If I had known enough to read the HTML standard on Floating Objects, I wouldn't have taken up your time. Thanks for the information. I did try the variations of the <BR> tag suggested by Rudy. The first worked in all browsers. However, the second variation <br...

Just a quick look at your code, but it looks like you read the base file into a variable RTF outside of your loop so it comes in once. Then the first time you loop you replace the data placeholders with the real data. Any loop after that would not find any placeholder to replace.

As you suggest the ALIGN attribute is for the table not the cells within the table. We are not having any difficulty in left or right aligning text inside a cell. The troubling behavior is in the second table on a page displaying to the left or right of the master table (that includes...

We have observed a strange behavior of the HTML <TABLE> tag. If the ColdFusion module does not specify the ALIGN=&quot;alignmentSpec&quot; attribute for the tag, everything displays as expected. Most specifically, the ColdFusion debug information is under the table. If I specify...

Carp, I think I am safe. The work I am doing is entirely in new tables being added to the server's database. Our DBA should have no concern over data lost. There isn't any yet. Fran

I think you are correct. I created a new table called fmrDocsJunk. I put it up on the server and the command worked for that table. Earlier today I created a PRIMARY KEY on just fmrItemId in the fmrDocs table. I guess in order to drop the constraint from the fmrDocs table, I must first...

Mufasa, Let me supply a little background. I am submitting the Oracle commands through ColdFusion. We have a little utility that I wrote that passes the SQL statement directly through. I have successfully added 18 tables this morning and applied all of the single-field primary key...

Can anyone tell me how to create a primary key on two fields? I have a table called &quot;fmrDocs&quot;. It has two numeric fields called &quot;fmrItemId&quot; and &quot;ptChgNumber&quot;. Both of those values are required to uniquely identify the record. I have tried to list the two fields...