| Adding dynamic tables... [message #51666] |
Wed, 05 June 2002 09:21  |
Kyle Willman
Messages: 2
Registered: June 2002
|
Junior Member |
|
|
I am looking to use a set of temporary tables (about 5) to accomplish an import routine (among other things). I am considering using a naming convention of : USERID_TABLENAME where the USERID is the ID that the user logged into the app as. My question:
Will Oracle handle the creation and deletion of these tables (approx 100 concurrent users) on a dynamic basis?
They will be created and dropped often. Thanks in advance for any help!
Kyle Willman
PricewaterhouseCoopers LLP
Houston, TX
kyle.b.willman@us.pwcglobal.com
|
|
|
|
| Re: Adding dynamic tables... [message #51667 is a reply to message #51666] |
Wed, 05 June 2002 09:31  |
tt
Messages: 16
Registered: September 2000
|
Junior Member |
|
|
you can create a pl/sql routine to create tables dynamically, given you supply the user_id's to the procedure. Check out the dbms_sql package for dynamic sql..
Regards,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
