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:
Production Of Football Photoshop 7.0
My FAVORITE Fax Tools
Journey to the West to build COSPLAY Mito Xiu Xiu
ASF converter
MKV to iPod
Tencent said THE prosecution did not rule out the possibility 51.com
Another Pair Of Eyes CMMI [2]
Shop Launchers And Task Managers
recommended free image editing software
Learning organization's five state
VOB To MP4
Principles of CD burning type of identification
Production of glass filter with Layer Style button (1)
No comments:
Post a Comment