crystal reports barcode generator Ensuring Tablespaces Are Self-Contained and Making Them Read-Only in Font

Drawing QR Code in Font Ensuring Tablespaces Are Self-Contained and Making Them Read-Only

Ensuring Tablespaces Are Self-Contained and Making Them Read-Only
Quick Response Code Generation In None
Using Barcode creator for Font Control to generate, create QR Code image in Font applications.
www.OnBarcode.com
PDF-417 2d Barcode Maker In None
Using Barcode maker for Font Control to generate, create PDF-417 2d barcode image in Font applications.
www.OnBarcode.com
Ensure that the tables you want to transport are all placed in their own separate tablespaces. To ensure that your tablespaces are self-contained, you need to use the TRANSPORT_SET_CHECK procedure in the Oracle-supplied DBMS_TTS package. In Oracle Database 10g Release 2, you can also use the TRANSPORT_FULL_CHECK parameter while performing the export, to ensure that the tablespaces don t contain dependent objects. For example, setting the TRANSPORT_FULL_CHECK=Y specification ensures that the tablespaces you are exporting won t contain tables without their indexes or any indexes without the parent tables. Also, alter the tablespace to make it read-only. Once you complete the export of the metadata in the next step, you can make the tablespace read/write again.
Print Barcode In None
Using Barcode creator for Font Control to generate, create Barcode image in Font applications.
www.OnBarcode.com
Printing DataMatrix In None
Using Barcode generation for Font Control to generate, create Data Matrix 2d barcode image in Font applications.
www.OnBarcode.com
Exporting the Metadata Using Data Pump Export
Create Code 128C In None
Using Barcode generation for Font Control to generate, create Code128 image in Font applications.
www.OnBarcode.com
Creating Code 39 Full ASCII In None
Using Barcode creation for Font Control to generate, create USS Code 39 image in Font applications.
www.OnBarcode.com
Export the metadata describing the objects in the tablespace(s), by using the TRANSPORTABLE_ TABLESPACES parameter, as described earlier in this chapter.
GS1 128 Maker In None
Using Barcode generation for Font Control to generate, create EAN / UCC - 14 image in Font applications.
www.OnBarcode.com
Making ANSI/AIM I-2/5 In None
Using Barcode encoder for Font Control to generate, create ITF image in Font applications.
www.OnBarcode.com
CHAPTER 14 USING DATA PUMP EXPORT AND IMPORT
Quick Response Code Creator In Java
Using Barcode encoder for Android Control to generate, create QR image in Android applications.
www.OnBarcode.com
Create QR Code 2d Barcode In C#.NET
Using Barcode printer for .NET framework Control to generate, create Denso QR Bar Code image in Visual Studio .NET applications.
www.OnBarcode.com
Converting the Data Files to Match the Endian Format
Encode UCC-128 In Java
Using Barcode printer for Java Control to generate, create USS-128 image in Java applications.
www.OnBarcode.com
DataMatrix Recognizer In VB.NET
Using Barcode recognizer for Visual Studio .NET Control to read, scan read, scan image in .NET applications.
www.OnBarcode.com
If your platforms are compatible, but the endian formats are different, you need to convert the data files. You may perform the conversion before transporting the tablespace set or after finishing the transport. You can convert the data files before transporting the tablespaces, using the CONVERT TABLESPACE command in the Recovery Manager (RMAN) utility, as shown in Listing 14-12. Listing 14-12. Using the RMAN CONVERT TABLESPACE Command to Convert Data Files RMAN> CONVERT TABLESPACE finance_tbs01 2> TO PLATFORM 'HP-UX (64-bit)' 3> FORMAT '/temp/%U'; Starting backup at 09-MAY-05 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile conversion input datafile fno=00011 name=C:\ORACLE\TEST02.DBF converted datafile=C:\TEMP\DATA_D-FINANCE_I-2343065311_TS-TODAY_FNO-11_05FLAUM6 channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:17 Finished backup at 09-MAY-05 RMAN> exit Recovery Manager complete. This example shows how you can use the FORMAT parameter to tell Oracle what format the newly converted file should be and in which directory to put it. But as you can see, Oracle gives the file a name. If you want to specify the name of the data file yourself, perform the conversion using the DB_FILE_NAME_CONVERT clause. Listing 14-13 shows the results of using the CONVERT TABLESPACE command with the DB_FILE_NAME_CONVERT clause. Listing 14-13. Converting Filenames with the DB_FILE_NAME_CONVERT Clause RMAN> CONVERT TABLESPACE test 2> TO PLATFORM 'HP-UX (64-bit)' 3> DB_FILE_NAME_CONVERT = 'c:\oracle\test.dbf','c:\temp\test.dbf'; Starting backup at 10-MAY-05 using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=151 devtype=DISK channel ORA_DISK_1: starting datafile conversion input datafile fno=00011 name=C:\ORACLE\TEST.DBF converted datafile=C:\TEMP\TEST.DBF channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:16 Finished backup at 10-MAY-05 RMAN> The DB_FILE_NAME_CONVERT clause performs the following functions for you: Takes a given filename and converts it to any filename you specify Places the converted file in the location you specify Note that you use the DB_FILE_NAME_CONVERT command when you convert the files directly on the source system, before transporting them.
Linear Generator In VS .NET
Using Barcode encoder for ASP.NET Control to generate, create Linear image in ASP.NET applications.
www.OnBarcode.com
Generating PDF 417 In Java
Using Barcode printer for Android Control to generate, create PDF417 image in Android applications.
www.OnBarcode.com
CHAPTER 14 USING DATA PUMP EXPORT AND IMPORT
Code 3/9 Scanner In None
Using Barcode scanner for Software Control to read, scan read, scan image in Software applications.
www.OnBarcode.com
PDF-417 2d Barcode Creation In Java
Using Barcode maker for Java Control to generate, create PDF 417 image in Java applications.
www.OnBarcode.com
Copying the Files to the Target System
Make Code 3/9 In VS .NET
Using Barcode drawer for VS .NET Control to generate, create Code 39 image in .NET applications.
www.OnBarcode.com
USS Code 39 Drawer In Java
Using Barcode printer for BIRT Control to generate, create Code 3 of 9 image in Eclipse BIRT applications.
www.OnBarcode.com
At this point, you need to copy both the converted data files that is part of the tablespace (finance_tbs01 in this example) as well as the expdp dump file, which was named sales.dmp in the earlier transportable tablespaces example, over to the target server where your target database is running. If you chose to transport the tablespaces (the data files that constitute the tablespaces) first instead, you must convert the data files on the target platform at this point, before trying to perform the import of the metadata in the tablespace. Here s an example that shows how you can take a data file that belongs to the HP-UX operating system platform and convert it into a Windows platform: RMAN> 2> 3> 4> CONVERT DATAFILE 'c:\audit_d01_01.dbf' TO PLATFORM 'Microsoft Windows IA (32-bit)' FROM platform='HP-UX (64-bit)' FORMAT '\u01\oradata\finance\export';
Painting UCC - 12 In Java
Using Barcode creator for Android Control to generate, create Universal Product Code version A image in Android applications.
www.OnBarcode.com
Reading GTIN - 13 In .NET Framework
Using Barcode reader for Visual Studio .NET Control to read, scan read, scan image in Visual Studio .NET applications.
www.OnBarcode.com
As in the previous example, where you performed the file conversion on the source system, you may use the DB_FILE_NAME_CONVERT clause when performing the data file conversion on the target system. Your data file conversion statement would then have the following format: CONVERT DATAFILE . . .FROM PLATFORM . . .DB_FILE_NAME_CONVERT... Here s an example that shows the use of the DB_FILE_NAME_CONVERT clause: RMAN> CONVERT DATAFILE 2> '/hq/finance/work/tru/tbs_31.f', 3> '/hq/finance/work/tru/tbs_32.f', 4> '/hq/finance/work/tru/tbs_41.f' 5> TO PLATFORM="Solaris[tm] OE (32-bit)" 6> FROM PLATFORM="HP TRu64 UNIX" 7> DB_FILE_NAME_CONVERT= 8> "/hq/finance/work/tru/", "/hq/finance/dbs/tru" 9> PARALLELISM=5;
Copyright © OnBarcode.com . All rights reserved.