Solved

schema import

Posted on 2014-04-22
5
405 Views
Last Modified: 2014-05-01
I want to import the schema with the same username and password.

I have the ddl of the source schema.

What is the first step I have to do?
0
Comment
Question by:vangogpeter
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40015394
Are you wanting to create a schema in a new database using a script with all the DDL?

If so, create the user in the new database, connect to the database using that new user and execute your script.
0
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 500 total points
ID: 40015553
If you want to extract the information of a schema then refer to a similar question here..


http://www.experts-exchange.com/Database/Oracle/Q_28413222.html

refer to steve's comment and my comment in the above question
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40015563
>>If you want to extract the information

They mention that they already have all the DDL.  Not sure how that post helps?
0
 

Author Closing Comment

by:vangogpeter
ID: 40020221
This is fine.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40020265
Can you explain the accepted answer?

That link shows you how to extract the DDL for a schema and not how to use it once you have it.  You stated you already had the DDL.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question