Ask a Question related to Coldfusion Database Access, Design and Development.
-
tbemcf14 #1
Create Table Through Coldfusion
Hello,
I'm trying to create a table through Coldfusion, but I keep getting the
following Oracle error:
ORA-01031: insufficient privileges
Is it possible to create a table through Coldfusion using CF 5 and Oracle 8i?
The create table sql works in Toad, so it seems that I have the appropriate
privileges.
Here's the code I'm using:
<CFQUERY NAME="CreateTable" DATASOURCE="#myDSN#" dbtype="Oracle80">
create table myschema.newtable as
select col1, col2 from myschema.sometable
</CFQUERY>
Is it my DSN, or can it not be done, or something else?
Thanks in advance for any help,
Mark
tbemcf14 Guest
-
create table space
i am using db2 udb v8.1 for windows 64 bit, based on the doc, i can create DMS to achieve high performance, to add the container, i can do file or... -
Using ColdFusion to create directories
I was wondering if it is possible to use ColdFusion to dynamically create directories. For example, I have a form that a user fills out (First... -
How to create a table with dynamic table name
<html><div style='background-color:'><DIV> <DIV class=Section1> <P class=MsoNormal style="mso-layout-grid-align: none"><FONT face="Times New Roman"... -
CREATE TABLE IN ACCESS
Hi all, Quick question, how do you create a table in MS Access from with an asp script? I will be creating the table name from ... -
Use sequense in Create Table
In Oracle 9.20.1.0, there is a error in " autoUid.nextval uid" this is statement SQL: create table AAA as ( select autoUid.nextval uid , makh,... -
paross1 #2 Re: Create Table Through Coldfusion
It looks like the user account assigned to your DSN lacks the appropriate privileges to create database objects.
Phil
paross1 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
