Iam with Export utility . I exported full database.
When try to improt it i am receiving a error . how to import fulldatabase . but i now the command .
what are the step's i have to follow .
import will work only on new database or existing one also.
If you dump of your full database then in import command syntax you have to give Full=Y and specify path for your exported dump file. Thru this you should be able to import full database.
imp username/passwd Full=Y Ignore=Y Commit=Y file=
For import the full database:
1. Drop all files associated to the database;
2. Create a new database with the same database name,sid ...
3. Run catalog.sql catproc.sql ...
4. Run import with parameter full=yes. This will create for you all tablespaces in the database, but it is better to create it before running the import.
Hope that helps
Click Here to Expand Forum to Full Width