right now i am studying my final year UG degree. i have developed my project in VB and ORACLE 8i...now i want to execute my project in my college.... now whats the problem is i have to create tables every time in another system.... so i want to bind the selected tables from my machine (example,.. table1,table2,table3,emp_table.....) and want to extract in the naive user system.....help me plzzzzzzzzzzzzzz..how to do this........ thanks in advanceeee
karan_21584
0
Light Poster
rdhiravani
0
Light Poster
exp <db_username>/<password> file=<file_name.dmp> tables=<comma_separated_lists_of_tables>
imp <db_username>/<password> FILE=<file_name.dmp> ignore=y rows=y commit=y tables=<comma_separated_lists_of_tables>
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.