unload data

[login1]

hi all,
I am using oracle 10g.How to unload ( create command and data ) from table to file.using any command.
Is it possible to load like this:

CREATE TABLE TABLE1( COL1 NUMBER, COL2 VARCHAR(10) )
/
INSERT INTO TABLE1 VALUES (
:1,
:2)
\
$DATATYPES NUMBER, CHARACTER
1,"ASD",
2,"ASDF"

Thanks in advance.

[debasisdas]

frankly io am not getting what do u mean by unload

what exactly u want to do

[login1]

frankly io am not getting what do u mean by unload

what exactly u want to do

Thank you for your reply.
I need to export data from oracle and need to import into sqlbase. so i asked in that format. in sqlbase we had command for unload as UNLOAD SQL FILENAME.SQL TABLENAME;. Sorry i am new to oracle. If i use that sqlbase command i will get in that format. and i can easily load to sqlbase.
so i asked any help.

[debasisdas]

if u want to export from oracle it is sop simple by using the EXPORT utility.

at sql*plus type host

then at the command prompt use

exp username/password@host_name

then just follow the instructions

it will create .dmp file which can be used to recreate the entire table / user schema / database based on the option created at the time of export.


but iam not sure u can use that file to import into another dabse like sqlbase or not.