VB.NET is still relatively common, so I've done some research VB.NET transmission table space out here and share with you, we want to be useful. Two databases (ltdb and epras), derived from ltdb tsts table space (user ts, including two data files) to epras
Steps
1.ltdb Exporting Transportable Tablespaces (to sysdba implementation of export) to the dmp file
2. Will ltdb the tsts tablespace to read-only
3. With the operating system command to copy the data files and dmp file to another location to another database epras use. If one server, dmp files can not copy, reproduce completed, will ltdb the tsts tablespace to read-write
4. Epras ts user database is created (this time without authorization)
5. Importing table space can VB.NET transmission (in sysdba implementation of import) to the dmp file to epras database
6. Epras the tsts table space will be changed to read and write, to ts authorized users
Benefits: and the data exp / imp than the fast, dmp files contain only 10g tablespace metadata support different platform tablespace transport, support Big Head / Head of transmission between the operating system version before the oracle can transmission characteristics of the table space can make the table space in the same architecture and operating systems migration.
In Oracle Database 10g, this limitation disappears: the same byte order as long as the operating system, you can transport tablespaces between platforms VB.NET. Some operating systems (including Windows) in the low memory address least significant byte stored using multi-byte binary data; so this system is known as low-address low-byte order. In contrast, other operating systems (including Solaris) will be most significant byte is stored in low memory addresses, so this system is known as low-address high byte order. When a low-address high-byte order of the system tried to address low-byte from a low-order system to read data requires a conversion process - otherwise, the byte order will lead to the correct interpretation can not read data.
However, when the platform in the same byte order transfer table space between the VB.NET do not need any conversion. 10g tablespace cross-platform migration, compared with 9i is to increase the use Rman to a file format conversion process.
Check the table space to be converted
EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK ('tswin1, tswin2', TRUE); PL / SQL procedure successfully completed. 'Is there a conflict SELECT backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp FROM TRANSPORT_SET_VIOLATIONS; no rows selected 'run rman rman TARGET / CONVERT TABLESPACE tswin1, tswin2 TO PLATFORM' Microsoft Windows IA (32-bit) 'FORMAT' / tmp / rman /% U ';' in the above example, the converted file name is difficult to identify and difficult to associated with the original files 'can also use other formats for the data file named CONVERT TABLESPACE tswin1, tswin2 TO PLATFORM' Microsoft Windows IA (32-bit) 'db_file_name_convert' / tmp / LTDB ',' / tmp / rman '' This will converted to retain the file name. backup / bin / conf / data / log / maint / svn / tmp /
Recommended links:
Managed and leased operators should pay attention to the problems and suggestions
flv to mp3 converter free download
3G has Not yet played the most intense competition
Expert Audio Video TOOLS
My Favorite Web Servers
Hot PIMS And Calendars
Photoshop pumping effect of the new line of thinking
video CONVERTER mp4 to mpeg
"Fallout 3" aircraft carrier task of the city of clues and details of the extension
Flac to mp3 converter free
Visuanl C # 2005 Quick Start of the while statement (2)
Let my mailbox, "all set" to complete easy COLLECTION
ts video Format
Learning organization's five state
My favorite HOBBY
Cottage in China
No comments:
Post a Comment