Wednesday, October 1, 2008

one import tables to a different tablespace

Can one import tables to a different tablespace? (for DBA)


Oracle offers no parameter to specify a different tablespace to import data into. Objects will be re-created in the tablespace they were originally exported from. One can alter this behaviour by following one of these procedures: Pre-create the table(s) in the correct tablespace:
. Import the dump file using the INDEXFILE= option
. Edit the indexfile. Remove remarks and specify the correct tablespaces.
. Run this indexfile against your database, this will create the required tables in the appropriate tablespaces
. Import the table(s) with the IGNORE=Y option.
Change the default tablespace for the user:

. Revoke the "UNLIMITED TABLESPACE" privilege from the user
. Revoke the user's quota from the tablespace from where the object was exported. This forces the import utility to create tables in the user's default tablespace.
. Make the tablespace to which you want to import the default tablespace for the user
. Import the table

What do you mean by a block in forms4.0? 
Block is a single mechanism for grouping related items into a functional unit for storing, displaying and manipulating records.

How is possible to restrict the user to a list of values while entering values for parameters? 
By setting the Restrict To List property to true in the parameter property sheet.

What is SQL*Loader and what is it used for? (for DBA)
SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Its syntax is similar to that of the DB2 Load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads.


No comments:

Post a Comment

Thanks to given comments.......

My Blog List