> Does anyone know how to use a different tablespace using PB403 and
>Oracle 7.1. I have a USERS space for user tables and I just created a space
>for TEMP tables. I need to be able to transfer data between both but cannot
>figure out how. I looked up all I could in the PB help and checked out
>their faxline and WEB pages for help. I do not even know how to get
>around PB's default behavior of automatically using the tablespace for
>the logged on user. Do I have to make another connection to the temp space?
> Thanx in advance.
> Joe M.
>--
If I understand what you are asking then you're solution is fairly simple. Stop using the powerbuilder
visual tools to build your tables. Instead write a sql script with your create table statements, then use
the tablespace clause to specify which tablespace to build the table in. Note that you will need to
grant quota on the tablespace to the account, before you create the table. You can then use sqlplus
(or any tool that will run a script, i think powerbuilder will even do it) to run your script. If you are using
the pb visual table builder then you are doing your database a disservice, because you also cannot
specify storage parameters for the table, nor for any indexes, and an oracle database doesn't 'like'
poorly considered storage parameters.
--
Tony Noble
Opinions expressed do not necessarily reflect those of my employer.