Home » RDBMS Server » Server Utilities » "create" and "export schema" merged
"create" and "export schema" merged [message #248685] Sat, 30 June 2007 07:35 Go to next message
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
Re: export schema [message #248691 is a reply to message #248685] Sat, 30 June 2007 09:51 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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 Go to previous messageGo to next message
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
Re: Create [message #248883 is a reply to message #248881] Mon, 02 July 2007 10:06 Go to previous messageGo to next message
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
Re: Create [message #248885 is a reply to message #248883] Mon, 02 July 2007 10:11 Go to previous messageGo to next message
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
Re: Create [message #248891 is a reply to message #248885] Mon, 02 July 2007 10:30 Go to previous message
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"

Previous Topic: test trigger
Next Topic: users in databse
Goto Forum:
  


Current Time: Sat Dec 03 22:10:43 CST 2016

Total time taken to generate the page: 0.07975 seconds