I have a number of Objects owned by a user called DBO. The objects have been mistakenly created in the tablespace SYSTEM.
Is it possible to move these objects to a different Tablespace? Is there a statement that can do it? Some of the objects are LOBs, Indexes , Tables.