DBA Tools

ALTER TABLE ... MODIFY DEFAULT ATTRIBUTES ...

    When doing transportable tablespace, we get the following errors when run the TTS set check procedure. SQL> EXECUTE dbms_tts.transport_set_check('USERS', TRUE, TRUE); PL/SQL procedure successfully completed. VIOLATIONS -------------------------------------------------------------------- Default Partition (Table) Tablespace USERS for ... not contained ... Default...

Posted on November 2, 2007 4:40 PM

Is it dangerous to change the table owner in this way?

    SQL Server and Sybase provide a system procedure to do this job, while Oracle hasn't it. And now I receive a task to move few tables (totally 80gb) from one schema to another schema. I tested this using...

Posted on September 19, 2007 2:13 PM