Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: copying orace schema
In article <1037610133.360794_at_sj-nntpcache-3>, prkothan_at_hotmail.com
says...
> Hi all,
> I need to copy the schema of my project.
> I require all the tables with data to be copied into new tablespace &
> username.
> Can anyone suggest me a easy way to do it.
>
1. export the database using the "owner" parameter.
2. import the database using the "fromuser" and "touser" parameters.