How to create a database in oracle? How can we copy a table in oracle and put it into another systyem?

Question

A table in an oracle database can be created by 'create table' command. After creating a table how can we put it into a database and copy it to another system

Answer 1

Make sure that u've LAN-connection & u've installed Oracle (don't know which version u're using, I do use 9i) in server-mode. If these two 're alright, then u shouldn't have any problem to open that table in another system. Otherwise create a new-user, first log in through..........

user: system
password:manager

create user identified by ;
"user created"
grant resource,connect to ;
"grant succeeded"
conn /
"connected"

Then create that table again.

Answer 2

Your question is not very clear. Clarify it properly.

Supposing that u want to transfer a table fro one database to another, there is some thing called export and import. U r to use that. Not from sql*Plus but from command prompt. Before doing that u r to know a lot. That's a task of DBA, not of a novice.

This site is still under construction. U may visit it a few days later.

http://defttips.googlepages.com/defttips

There we shall try to answer u if u ask ur question clearly.