Tag Info

New answers tagged

0

SELECT * FROM (SELECT CASE WHEN default_Tablespace = 'tablespace-A' THEN 'alter user ' || username || ' quota unlimited on tablespace-B;' END stmt FROM dba_users UNION SELECT CASE ...


0

Why using original Export and Import utilities (imp and exp respectively), which are deprecated, while since 10g Oracle provides a new, more efficient facility called Data Pump? You can use Data Pump Import with REMAP_TABLESPACE parameter to specify the new tablespace name for the objects being imported: $ impdp hr REMAP_TABLESPACE=tbs_1:tbs_6 ...


0

No, you just can't copy and paste datafiles. In order to do so, you must first export (with exp/imp tools) the tablespace as a transportable tablespace, then copy the datafiles, and finally import the dump file generated in the export process. But note that this wont work between different platforms (that feature is from 10g on ahead) Instead, you can just ...


1

Yes, if you have all files placed in the same locations, you can create a pfile, make it point to the controlfile[s] and start the instance. If the backup was a clean cold backup, it should open without any problems. Don't forget to also enter the name parameters and the dump destination parameters for the database. You should restore at least the system, ...


6

In DB2, a tablespace is the object that serves as a layer of abstraction between tables (and indexes) and disk. It is similar to a file group in MS SQL Server. In DB2, a database is roughly equivalent to a SQL Server instance – a database contains multiple tablespaces, transaction logs, one or more bufferpools and other memory areas. A "database" in ...



Top 50 recent answers are included