Re: Oracle import from NT to NT

Excuse me for butting in, but I work with the original poster of this thread. The export is a full database export. We are trying to move a project from development to production and understood export/import with full is the best way to go. However, export/import does not include any SYS owned objects. Do you have any suggestions? As mentioned, those users with DBA roles or have the DEFAULT profile seem to have all association data (passwords, default tablespace, temporary tablespace, etc.) retained after the import. Those with our defined profile(s) do not have their passwords, default tablespaces, and temporary tablespaces retained. Any suggestions?

In article <01be7fea$44a28910$5065a3a8_at_pmaaumissv5124>,   "Zdenka" <zspoljar_at_pm.com.au> wrote:
> What type of export did you take ? Was it a full export or something else
> ?
>
> Regards
>
> kvabg_at_ttacs1.ttu.edu wrote in article <1999Apr5.181159_at_ttacs1>...
> > Hi,
> > I've imported the full database from one NT to another. But some users,
> who has
> > a profile other than "default" lost their passwords, assigned
> tablespaces, etc.
> >
> > However, I have that specific profile and table spaces.
> >
> > So what could be the reason? Please respond ASAP.
> > Please send your response to bgumus_at_onboard-software.com
> > Thanks
> >
> >
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 08:59:17 CDT