On Mar 22, 8:41 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Brian Peasland wrote:
> > Matthias Hoys wrote:
> >> How about:
>
> >> CREATE USER LIKE ...
>
> > That would be a great idea! Either that, or the ability to use
> > DBMS_METADATA.GET_DDL to reverse engineer the CREATE user statement
> > *along with* the necessary GRANT statements.
>
> > Cheers,
> > Brian
>
> You mean like this?
>
> SQL*Plus: Release 10.2.0.2.0 - Production on Thu Mar 22 17:39:44 2007
>
> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> set long 1000000
> SQL> select dbms_metadata.get_ddl('USER', 'UWCLASS') from dual;
>
> DBMS_METADATA.GET_DDL('USER','
> ----------------------------------------------------------------
>
> CREATE USER "UWCLASS" IDENTIFIED BY VALUES '6DC6701F46477E93'
> DEFAULT TABLESPACE "UWDATA"
> TEMPORARY TABLESPACE "TEMP"
>
> SQL>
>
> Now if only it provided quotas and privs. <g>
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
I bet there won't be something like:
SELECT * EXCEPT (col1, col2, col2) -- select all columns except
(col1, col2, col2)
FROM table_with_43_columns; -- which I'd love, but yet have to live
without it:)
Received on Fri Mar 23 2007 - 14:36:04 CDT
