473,379 Members | 1,201 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

how to move one schema db to another schema db using toad 9.5?

ramanan ram
hi,
i trying to move one schema tables with constraints ,functions and procedures to another db schema.

example:
from :db name: poms,
schema :pipeline
TO:
db name: prmy
schema: tapestry

please give solution...
Dec 8 '12 #1
1 2267
debasisdas
8,127 Expert 4TB
You need to use the utilities EXP/EXPDP and IMP/IMPDP depending on the versions of the oracle that you are using.
Dec 10 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Stoggers | last post by:
Hi, Anyone got any examples of XSLT to translate a schema into another schema? I need to change the datatype on elements. Thanks, Stoggers.
1
by: Rizaan Jappie via DotNetMonster.com | last post by:
hi where can I find the Visual Studio.Net Project XML Schema (.csproj schema) for c#. I need to build a DOM (document object model) that automates the process of creating c# project files(.csproj)...
0
by: ad | last post by:
I have a xml file, it have a DTD declaration like below <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE HealthData SYSTEM "Health.dtd"> .... Now I want to verify the xml file with another...
1
by: tmaster | last post by:
Within a class, can I create a property that is a listview? Here's what I tried, but it doesn't seem to work: '------------ create property to give the second form access to the first form's...
6
by: Sakharam Phapale | last post by:
Hi All, How to move the CommandButton control using mouse from one position to other? Is it possible using Drag, Drop events or I have to write my own code for that? I have set the...
1
by: mflll | last post by:
How does one say in one schema that one wants an element defined in another schema. For example, I want to include in the Employee definition, an Address element defined in the schema...
4
by: system55 | last post by:
I need some help.... How can i create a program wherein it can copy a file about 2MB in size, into another file using the extended memory allocation??? Do i need to use some interrupt calls in dos??
3
by: islandfong | last post by:
I am trying to copy data from one schema to another schema using TOAD connecting to Oracle 10i. Some of the tables can be copied smoothly but two some of them cannot. There is no error message given,...
10
by: Debajit Adhikary | last post by:
I have two lists: a = b = What I'd like to do is append all of the elements of b at the end of a, so that a looks like: a =
3
Inbaraj
by: Inbaraj | last post by:
Hi.. I want to take the back up of a schema in oracle using C# codeing is it possible is yes plz help me with sample codeing.. reg Inbaraj.d
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.