OraFAQ Forum: Server Utilities » "create" and "export schema" merged

Home » RDBMS Server » Server Utilities » "create" and "export schema" merged

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"create" and "export schema" merged [message #248685]

Sat, 30 June 2007 07:35

qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia

Member

Is any body have idea how to export the whole schema from one database to another database.

Thanks in advance

Report message to a moderator

Re: export schema [message #248691 is a reply to message #248685]

Sat, 30 June 2007 09:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is any body have idea how to export the whole schema from one database to another database.

By using the export utility; "exp".

exp help=yes

exp myschema/password file=myschema.dmp log=myschema.log owner=myschema statistics=none

[Updated on: Sat, 30 June 2007 09:57] by Moderator

Report message to a moderator

Create [message #248881 is a reply to message #248685]

Mon, 02 July 2007 10:03

qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia

Member

Is anybody can share the script with me for this. I need to export all of mine production users to my new database. i just need to create only user id with the default table space.

oracle version
9.2.0.6.0

thanks in advance

Report message to a moderator

Re: Create [message #248883 is a reply to message #248881]

Mon, 02 July 2007 10:06

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

example some thing like this...
exp scott/tiger FILE=scott.dmp OWNER=scott GRANTS=y ROWS=y COMPRESS=y

Report message to a moderator

Re: Create [message #248885 is a reply to message #248883]

Mon, 02 July 2007 10:11

qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia

Member

I don't need the whole database object. I just to create the users in the new database from production database.

Thanks in advance

Report message to a moderator

Re: Create [message #248891 is a reply to message #248885]

Mon, 02 July 2007 10:30

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

You dont want the data??
You only need to export only USERS??

  1*  select dbms_metadata.get_ddl('USER','ORACLE') from dual
SQL> /

DBMS_METADATA.GET_DDL('USER','ORACLE')
--------------------------------------------------------------------------------

   CREATE USER "ORACLE" IDENTIFIED BY VALUES 'F84B91CEAB6CEE58'
      DEFAULT TABLESPACE "mydb_USERS_TS"
      TEMPORARY TABLESPACE "mydb_TMP_TS"
      PROFILE "mydb_PROFILE"

Report message to a moderator

Previous Topic:	test trigger
Next Topic:	users in databse

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 19:50:08 CDT 2024