Simple table space to talk about Visual Basic.NET transmission

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:



mp4 to mp3 Converter



Convert flac to mp3



how to convert avi to wmv



Lists Newsgroup Clients



Expert Vehicles - Screen Savers



Demo Write On The Slide



introduction Games Sports



PERSONAS - Firefox you what to wear today?



Why three heads than a strong - how to build a knowledge-sharing-based company (2)



ps3 RMVB



The staffing Arrangements in the most appropriate location



CMMI: Tailored, Is The Fundamental



Review Telnet Servers



Enhance the "soft environment" out of THE performance appraisal errors [3]



Alibaba IPO made to decrypt the rich mythology behind the movement