Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: create table grants and Dynamic SQL question
Ok, I'll give some background. :)
Let's rename the users in my example. a is called "meta", b is called "data". Tables in "meta" hold data that (among other things) describe tables in "data" and describe how to manipulate the data in the tables in "data". "Meta" ist the driving user where most of the application resides. Everything in "data" is generated in "meta": Tables and some table specific packages of code. I want to keep the meta-data and the acutal data-data seperate, as everything in "data" is derived from "meta"-information and program logic (and some user input gained through a web interface, but that's another story).
Later another person than me will want to do something with these tables, so they need to persist. That later part is out of my control, I just create the database and provide the program to fill it, driven by meta-data that I find in CSV files.
It works well, nice and fast, in principle - but so far I used to write the generated code into text files (e.g. "create_this_table.sql" and call them via a batch that had to be called manually. I found no way to call that batch automatically, except to fumble around with Java. So I am trying to make it work without user interference using native dynamic SQL (which appears to have it's own caveats, more questions incoming soon).
Romeo Olympia wrote:
> I'm not exactly sure what you're trying to do. Looks to me that you > need a "work table" which you create, process, and drop all in one > user session. If this is the case, do check out Oracle Temporary > Tables. Not the same thing as PL/SQL tables you're referring to? > > But if you insist on this dynamic table create approach, CREATE ANY > TABLE system privilege will allow you to create a table in any schema. > > Cheers, > > Romeo > > FlameDance <FlameDance_at_gmx.de> wrote in message news:<c8qfd3$nkl$07$1_at_news.t-online.com>... >
![]() |
![]() |