Re: Alter session set current_schema

An interesting point, though, the Oracle internal processing that takes place when import does this is not the same as when an ordinary user does it.

I last checked this at about 7.1.4, but a user running this command from SQL*Plus would be able to:

	alter session set current_schema=new_schema;
	describe local_table

instead of 
	describe new_schema.local_table

However, in all other respects (e.g. CREATE TABLE) they would still be the original Oracle ID.

When IMP uses the command, it doesn't just change the current schema, it becomes the effective user at the same time.

Wouldn't that be a lovely facility for SYS to have ! Received on Tue Dec 10 1996 - 00:00:00 CET