DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to create any objects .... ?

  1. #1
    Join Date
    Sep 2005
    Posts
    2

    Post How to create any objects into .... ?

    How to create any objects in an another schema without put the owner ?

    Example : create table A as select * from NIKO.B

    Table A must be create into NIKO schema.

    Is it possible ? if Yes how ?
    Last edited by niko; 09-26-2005 at 05:36 AM.

  2. #2
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    Code:
    alter session set current_schema=niko;

    CURRENT_SCHEMA = schema

    The CURRENT_SCHEMA parameter changes the current schema of the session to the specified schema. Subsequent unqualified references to schema objects during the session will resolve to objects in the specified schema. The setting persists for the duration of the session or until you issue another ALTER SESSION SET CURRENT_SCHEMA statement.

    This setting offers a convenient way to perform operations on objects in a schema other than that of the current user without having to qualify the objects with the schema name. This setting changes the current schema, but it does not change the session user or the current user, nor does it give you any additional system or object privileges for the session.

  3. #3
    Join Date
    Sep 2005
    Posts
    2
    it's running

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width