- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Migrating a Subset of Data
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-10-2003 11:37 AM
тАО01-10-2003 11:37 AM
Migrating a Subset of Data
Any ideas are appreciated!
-Mary P.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-10-2003 03:16 PM
тАО01-10-2003 03:16 PM
Re: Migrating a Subset of Data
I wouldn't suggest this route unless you really know the application and data flow on all tables. presuming you know them, then you can create a dblink from dev to production and starting inserting rows. make sure to grant appropriate privs, reset sequence values if any..well, getting painful.
however there are other options which are safe and simple
export / import data
or
build the dev database from a hotbackup of production db.
or
export/import transportable tablespaces tts.
stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-10-2003 03:56 PM
тАО01-10-2003 03:56 PM
Re: Migrating a Subset of Data
It is extremely dificult to create sub-set database by hand.
e.g.
I want 20% of the data.
So I take 20% of transaction data and 20% of vendor data and 20% of the terms table.
Typically the three chunck won't line up.
e.g. The 20% of the vendors didn't include IBM ...and IBM transactions are part of the 20% of the transaction data I took. You could 'Add' IBM to the vendor list ... but you will have to that kind of analysis for every element/table in your database.
There are tools from comapniesl like http://www.applimation.com/ that might help. I have not used them though so I can't say .. I have only had their sales people call.
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2003 12:44 AM
тАО01-13-2003 12:44 AM
Re: Migrating a Subset of Data
Having said that, I am aware of a product designed to help this process, although I have no experience of it. Try http://www.databee.com/
- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2003 02:21 AM
тАО01-13-2003 02:21 AM
Re: Migrating a Subset of Data
You should create all the objects first (exp with rows=N then import) then get the data.
================================================================
set heading off
set feedback off
spool myscript.sh
select 'exp userid=/ owner=' || username || 'file=' || username || '.dmp rows=N &'
from all_users
where username not in ( 'SYS', 'SYSTEM', ...., 'DEVLOPMENT' );
spool off
host chmod a+x myscript.sh
host myscript.sh
================================================================
One way to get the data would be, as mentioned by one of the posters above, create a database link and use the sqlplus copy command or direct load inserts to populate your tables in the development database - You must know your tables/data well to be able to write the SQL statement. This might be a tidious job since there may be foreign key constraints preventing you in some cases. (although you may disable these constraints before doing it)
E.g. insert /*+ append */ into t select * from t@another_place
or
COPY FROM user/pass@instance_1 TO user/pass@instance_2 APPEND table_1 USING select_stmt
Another method is to use Export/Import - again you must know your tables well.
$ exp userid=/ tables=t query=\"where object_id \< 5000\"
or, if I simply use a parameter file with this in it:
query="where object_id < 5000"
I can now use the single command:
exp userid=/ tables=t parfile=exp.par
Hope this helps!
Best Regards
Yogeeraj