R
Rob Fitzpatrick
Guest
MT was added in 11.0, TDE in 10.2B. For TDE, you don't enable encryption by applying an incremental schema change. At a high level, you do it by: - installing the TDE license (Enterprise only) - enabling the DB for encryption (creates key store, requires passphrases) - creating encryption policies (one per Type I area, or per storage object in a Type II area; doesn't encrypt existing data) - (optionally) encrypting the existing data When you dump the schema from the DB, you will see DDL statements re encryption, at the object level and in the trailer. But as I said you can't make these changes by applying a .df. I haven't worked with MT but I believe it's a similar story, in that the schema may reflect your MT changes but they aren't applied to the database via a schema change. > Other than that is there really any other way to change the database structure than by using data dictionary/database administration? Changing the structure (i.e. changing areas) is done via prostrct. Can you elaborate on what you mean by "changing the structure"? Do you mean changing the assignment of objects to areas?
Continue reading...
Continue reading...