Q: 1. Blobspace 2.indexes and other object creation/update date
Posted in 1998
Topics: Storage & Space Management, Connectivity: ESQL/C, 4GL & Embedded SQL, Triggers, Constraints & Referential Integrity, Migration, Import/Export & Data Conversion
--=_360019500-159576444-10754816_= Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: 7bit Hi.... 1. I have question about the blobspace, currently, we got a 10GB blobspace for a text column. How can we do a re-org like unload and reload to a new dbspace. Any recommendation on 2k and 4k difference? What are your tips and hint? 2. I want to find out when is object get created such as the index for a table. triggers, store procedure etc. Any help would appreciate!! -Esther --=_360019500-159576444-10754816_= Content-Type: application/x-pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=smime.p7s MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIAwggGj MIIBDAIFAI9f+DUwDQYJKoZIhvcNAQEEBQAwGDEWMBQGA1UEAxQNUHJvdmlkaWFuTWFpbjAe Fw05ODA5MTAyMzIzNTlaFw0wMDA5MDkyMzIzNThaMBgxFjAUBgNVBAMUDVByb3ZpZGlhbk1h aW4wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMZtlPPxB/2zJQv2ZS+iFji0eli3KN+j 4aUCq/+cOfwYZaUbXQ52Mj9+lod5ILEBTlgcm17yVfHAXtt06aeZ503u4GtcTO422l8fsCQr 09g7VPwedzwU5cvbytQk9RxbPS3Xb6wclx2ni4KTkWemE5iPFEpkUmFYyymYI01VAgutAgMB AAEwDQYJKoZIhvcNAQEEBQADgYEAXYFa4gLmOqj3fsRzuAxSQo9uB1tARhIjRI4pgG2oPrbL 9r9/c+oBTaxIOV/NRfX9ypTtlncKaY65mV21Bfyq9XK0MGO5gUCJE5tL1IOC6VlkL55JfvEv CIrromAhf9ODfvj/gg/XN9v8teh9FnnoPvP8B15g0XmO70wPStUtlfYAADGAMIIBIgIBATAh MBgxFjAUBgNVBAMUDVByb3ZpZGlhbk1haW4CBQCPX/g1MAkGBSsOAwIaBQCgXTAYBgkqhkiG 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw05ODA5MjExOTU5NDFaMCMGCSqG SIb3DQEJBDEWBBSiBd12Wl+WgcavXBXJnoSaXhZSmzANBgkqhkiG9w0BAQEFAASBgEL+qpk4 uTCc5Hf9xh1hv549OavrMqsHr/J1LkxTW8/OhyS2yr8RL8vI0cggmMhQtaWe2gqiZ+VToGku 824wrhR+QGuy/ECtDi8NIERO+DEoUcGK8GTN5TeW3yJkId0jerAA5GxXL4ygPAzfXUcMdIfe LrAqHiQ7RJEpl/471p6KAAAAAAAAAAA= --=_360019500-159576444-10754816_=--