Database copy [message #500937] |
Thu, 24 March 2011 10:14 |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
Hi all,
I need to copy all the database objects from one database to another database.
I have 32 bit windows environment I tried export and put it in a dump file but dump file size exceeds the limit, my database size is about 300 GB.
What would be efficient way to replicate all the database objects move to another box ..?
any help is appreciated.
Thanks
JP
|
|
|
|
Re: Database copy [message #500939 is a reply to message #500938] |
Thu, 24 March 2011 10:21 |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
does RMAN copies all the objects like mat_views, packages, functions,procedures, tables,views, indexes ..?
Basically I need to copy/transfer all of the above object from one of my schema to another machine.
I am not a DBA know nothing about RMAN.
JP
|
|
|
|
Re: Database copy [message #500947 is a reply to message #500940] |
Thu, 24 March 2011 10:57 |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
Thanks BlackSwan. That's a helpful link.
One last thing If I want transfer all the objects is "Data Pump" be a good option .?
Please advise,
Jay
|
|
|
|
|
Re: Database copy [message #500950 is a reply to message #500948] |
Thu, 24 March 2011 11:04 |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
Hi Michel,
Need to copy mostly all database objects like (procedures, packages, functions,tables, mat views, indexes, views, sequences).
It need toby in Insync once a month. Currently my database is backed up offline (cold back-up once a week).
Thanks
Jay
|
|
|
|
|
Re: Database copy [message #500970 is a reply to message #500954] |
Thu, 24 March 2011 13:42 |
|
LKBrwn_DBA
Messages: 487 Registered: July 2003 Location: WPB, FL
|
Senior Member |
|
|
What remains unclear is if you also want to transfer the data or just the schema definitions.
If you DO NOT need the data, then you can use either export with the "ROWS=N" option or datapump with "CONTENT=METADATA_ONLY" option.
Good luck!
[Updated on: Thu, 24 March 2011 14:09] by Moderator Report message to a moderator
|
|
|
Re: Database copy [message #500976 is a reply to message #500970] |
Thu, 24 March 2011 15:21 |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
I need to have all the data basically It's a full replication of all database object for a schema to new box.
I have one question Is there a way I can filter out a table off full replication?
Thanks
J
|
|
|
|
Re: Database copy [message #501062 is a reply to message #500982] |
Fri, 25 March 2011 08:55 |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
Need to replicate all oracle objects from one oracle schema to a new machine except 2 tables.
I tried simple export
exp username/passwd@Instance filec=c:\test_export.dmp DIRECT=Y GRANTS=Y INDEXES = y LOG=C:\test_export.log STATISTICS=NONE;
but It failed because my database size is 350gb so my current 32 bit windows environment doesn't allow me store every thing here (test_export.dmp) in
one file. I am not sure how to break this task ?
Please advise
Jay
|
|
|
|
|
|
Re: Database copy [message #501069 is a reply to message #501066] |
Fri, 25 March 2011 09:30 |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
Hi Michel
Is data pump same as export ? I am confused between export and data pump.
Here is the Information:
SELECT sum(bytes)/1024/1024/1024 size_in_GB FROM user_segments; -- schema 131.91 gb
select sum(bytes)/1024/1024/1024 from dba_data_files; -- databse size 353.12 gb
select ((blocks*8192)-(blocks*avg_space))/1024/1024 "MB size", empty_blocks,avg_space, num_freelist_blocks from user_tables where table_name = 'CLAIMS'; --48GB (THIS TABLE ALREADY INTO SEPERATE TABLESPACE)
Thanks
J
|
|
|
|
|
Re: Database copy [message #501073 is a reply to message #501072] |
Fri, 25 March 2011 11:06 |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
SELECT sum(bytes)/1024/1024/1024 size_in_GB FROM user_segments where segment_name like 'CLAIMS'; --44.6 GB
CLAIMS is the table which I want to EXCLUDE off my export list.
Thanks,
Jay
|
|
|
|
|