This content has been marked as final. Show 10 replies
i am using generate ddl script to import the database schema from one system to another system....i run the script...but while exporting(running the imported sql script file into another system), it is not run properly...the database is not exported..can anyone say how to import the database?
What is the version of the database ???
You can use exp/imp utility to export your schema and import it in another database.
i used 2.0 , now i want to copy the database to apex 3.0
I want to know the version of database (9i,10g) ???
To export a schema,
On the database server, type
exp userid=system/xxxxx owner=your_schema file=your_schema.dmp log=exp_your_schema.log
To import the schema,
On the server where the 'import database' is
imp system/xxxxxx fromuser= "your_schema" touser="your_schema" file="your_schema".dmp commit=Y ignore=Y log=imp_"your_schema".log
Before that , verify that your schema is created in your database with APEX3.0
(elsewhere create user your_schema.....)
And after import,recompile all the objects if your schema contains procedures,packages,triggers...
the version of the database is 10g
If you are in 10g, so you can use datapump (even if exp/imp works)
Have a look at http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_api.htm
My system is stand alone one and installed with htmldb2.0 and my server is installed with htmldb3.0...There is no connection between my system and server system....So i could not use the following commands...
exp userid=system/xxxxx owner=your_schema file=your_schema.dmp log=exp_your_schema.log (to export)
imp system/xxxxxx fromuser= "your_schema" touser="your_schema" file="your_schema".dmp commit=Y ignore=Y log=imp_"your_schema".log (to import)
Can you say how to recompile all the objectrs of my schema from one system to server?
Do you mean that you don't have network connection between your system and the server??
Otherwise , launch exp on your system, (compress the dmp file if it is huge),copy the dmp file on your server (ftp if you have network, USB key else maybe), (decompress the dmp file), imp on your system in the directory where you put the dmp file.
To recompile all the objects your schema, log as sysdba on the server
and launch @/rdbms/admin/utlrp . (I don't know if the method is valid in 10g but it is in 9i). It will recompile all the invalid objects of your database.
Just replace @/rdbms/admin/utlrp by @?/rdbms/admin/utlrp
(? = ORACLE_HOME )
Please find below steps for importing and exporting schema in oracle
exp schemausername/password file=filename.dmp log=emp.log
imp file=emp.dmp fromuser=username touser=username
username: / as sysdba