transfer of oracle database 1

[goilaswati]

sir

my problem is that i am currently working on a project with a front end on vb and back end on oracle.
now after i complete this project i will have to submit it and there would be a viva in which i will have to give a live demo of the project. right now i have a tablespace in a database of a company.
how can i transfer this whole set of tables to another database within minutes.my project needs creation of the tables before executing the application.

what all can i do & how can i do it. please help

 

[sem]

You may use export/import utilities Regards, Dima

 

[cliousa]

The fast way of doing it is to use transportable tablespace. You have to put the tablespace where the tables are on READ-ONLY mode, copy the datafile to CD-ROM or tape, export the tablespace meta-data (takes seconds), then return the tablespace to READ-WRITE mode.

To have the tablespace in the new database, simple copy the datafiles and import the meta-data.

There are some limitations, but you can check them in the on-line docs ( as the same OS, same db_block_size, etc.)


Hope that helps,

clio_usa - OCP DBA
------------------

http://www.dbaclick.com