oracle master data management ppt

1, manually change the size of the data fileSql>conn/as SYSDBASql>createtablespace exampletb datafile ' e:\ examp01.dbf ' size 10M;Sql>alter database datafile ' E:\examp01.dbf ' resize 20m;Sql>alter database datafile ' E:\examp01.dbf ' resize 9m;2. Add data file to table spaceSql> alter tablespace EXAMPLETB add datafile ' e:\ examp02.dbf ' size 10M;3. Delete data

Hello, the following is the eighth lecture address of my oracle series training courses. This lecture mainly describes how to migrate databases across platforms! The main content involved is: 1: describes and demonstrates how to migrate a database on a windows operating system to a linux server, and convert the data file storage from the original NTFS file system to the storage on the ASM disk. 2: Describes

The WMS warehouse management system implements the "sending and receiving daily report" data query function. SQL statement: Oracle [SQL] www.2cto.com SELECT AA. PRODUCT_CNAME, AA. PRODUCT_ID, AA. PRODUCT_CODE, AA. MODEL, AA. MASTER_UNIT, AA. OTHER_UNIT, AA. PACKAGE_RATIO, AA. CUSTOMER, SUM (week) AS QTY_OUT_TODAY, QTY_TODAY, SUM (week) AS week, SUM (QTY_OUT) AS Q

CHAPTER ASM Persistent Data structuresAs with traditional file systems and volume managers, ASM storage metadata is used to describe and track the contents of a disk group. All metadata describes the composition and content of the ASM disk group stored above, which enables the disk group to be self-describing. ASM Disk groups have two types of metadata: physical metadata and virtual meta data. Physical meta

The role of the Undo Data Segment: Transaction rollback: The program executes the rollback operation. Transaction repair (TransactionRecovery): rollback is re The role of the Undo Data Segment: Transaction Rollback: The program executes the rollback operation. Transaction Recovery: rollback is re The role of the Undo data segment:Transaction Rollback: The pr

Disk DirectoryDisk directory contains information about all the disks in the disk group. Disk directory information is more detailed than PST. Each disc in a disk group has an entry that is indexed by a number. The file number of disk directory is number 2nd (F2) in each disk group.The fields in Disk directory are as follows:N Disk NameN Failure Group Namen Disk Sizen Disk Free Spacen Disk creation timeMost of the information in disk directory is available in the disk header. Alterdiskgroup ...