Set schema="yourdb" 
Author Message
 Set schema="yourdb"

That is because it is UNdocumented and UNsupported. On purpose. Oracle
may not keep it in future releases.

In the meantime, I use it, too.

Quote:

> Thanks!

> Unbelievable how hard it seems, to get this kind of basic stuff out of
> the Oracle docs and even relatively experienced users.

> Josh



> >alter session set current_schema = <your schema>;



> >> OK, there's no such command.  Or is there?  SQLServer has
> >> a "use" command that does the equivalent, ... or am I
> >> thinking of DBase III?

> >> I guess the approved approach in Oracle is to use roles, right?

> >> Josh



Sun, 01 Oct 2000 03:00:00 GMT
 Set schema="yourdb"

Aaaaarrggghhhh!!

Josh

On Wed, 15 Apr 1998 22:22:24 -0500, "John P. Higgins"

Quote:

>That is because it is UNdocumented and UNsupported. On purpose. Oracle
>may not keep it in future releases.

>In the meantime, I use it, too.


>> Thanks!

>> Unbelievable how hard it seems, to get this kind of basic stuff out of
>> the Oracle docs and even relatively experienced users.

>> Josh



>> >alter session set current_schema = <your schema>;



>> >> OK, there's no such command.  Or is there?  SQLServer has
>> >> a "use" command that does the equivalent, ... or am I
>> >> thinking of DBase III?

>> >> I guess the approved approach in Oracle is to use roles, right?

>> >> Josh



Mon, 02 Oct 2000 03:00:00 GMT
 Set schema="yourdb"

I wouldn't worry, they wont want to completely re-write the import/export
utility....


Quote:
>Aaaaarrggghhhh!!

>Josh

>On Wed, 15 Apr 1998 22:22:24 -0500, "John P. Higgins"

>>That is because it is UNdocumented and UNsupported. On purpose. Oracle
>>may not keep it in future releases.

>>In the meantime, I use it, too.


>>> Thanks!

>>> Unbelievable how hard it seems, to get this kind of basic stuff out of
>>> the Oracle docs and even relatively experienced users.

>>> Josh



>>> >alter session set current_schema = <your schema>;



>>> >> OK, there's no such command.  Or is there?  SQLServer has
>>> >> a "use" command that does the equivalent, ... or am I
>>> >> thinking of DBase III?

>>> >> I guess the approved approach in Oracle is to use roles, right?

>>> >> Josh



Tue, 03 Oct 2000 03:00:00 GMT
 Set schema="yourdb"



Quote:
>That is because it is UNdocumented and UNsupported. On purpose. Oracle
>may not keep it in future releases.

>In the meantime, I use it, too.

Ditto exactly. Whilst I am nervous about using undocumented features,
the only realistic alternative I could see in our scenario would have
involved dropping and creating dozens of private synonyms on the fly -
ugh. However, since Import also uses this feature, I feel reasonably
sanguine.
Regards,
--
Paul Brewer


Thu, 05 Oct 2000 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Set schema="yourdb"

2. "set current schema" and commit

3. max of ("...","...","..")

4. Extracting "Column Description" from schema

5. "Optimize Cube Schema" via script

6. Optimal Schema Design - "Enumerated Typed Fields"

7. "Schema"-equivalent in SQL Server

8. DTS with "dynamic" source schema

9. Todo "claim": psql tab completion on schema names

10. Privileges on "demo" schema

11. Defination of "SCHEMA"

12. "schema"


 
Powered by phpBB® Forum Software