Solved

schema import

Posted on 2014-04-22
5
401 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
  • 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

Technology Partners: 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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

680 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