Re: admin password in oracle

Boz wrote:
> Im a newbie to oracle but not to databases. Im using a shopfloor
> system that uses oracle. We have a live side and a demo side. What I
> want to do is put my live side into my demo side so that I have a copy
> of my existing live data to play with in the demo. Thus i can try new
> things without worry of messing up. In my old system which was
> pervasive system all i did was copy the .dta files into the demo folder
> and hey presto. Not sure with the oracle. At the moment i have to
> populate it manually. It would be nice to import fresh live data into
> the demo side of things. I can connect by ODBC but the password and
> username thats in the manual only gives me read access only. This must
> have been set by the company providing the product.

Oracle doesn't work that way. Do you have a DBA that can help you?

Basically for each table in the schema you don't want to alter you need to log onto that schema and grant SELECT on the table to the other schema. See my answer to another question just a minute ago or look at the examples at www.psoug.org, click on Morgan's Library, click on Object Privileges.

Then go to the second schema and recreate the table with:

CREATE TABLE <table_name> AS
SELECT * FROM <first_schema_name>.<table_name>;

Examples in TABLE at Morgan's Library.

HTH

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)