Does anyone know if its possible and how I can create a View in an Oracle Schema that connects to and points to a SEQUEL table on a SEQUEL database?
Any help about how to connect to SEQUEL from Oracle would be great.
I am using Oracle 7.3.4 Client and 8.06 Enterprise on a Windows NT server with service pack 6. I removed the oracle registry and then installed Oracle 8. The only thing you have to make sure of is that your PATH environment variable contains poiters to both Oracles and that the applications...
Thanks to all of you for your help.
The export was done using system and the export file looked like this:
FILE=e:\nib\proddmp\AIAPROD.dmp
STATISTICS=NONE
COMPRESS=Y
ROWS=Y
LOG=e:\nib\proddmp\AIAPROD.LOG
owner=AIAPROD
BUFFER=6000000
DIRECT=Y
AIAPROD is the schema owner and all the table belong...
Thanks for the help. The export was not done using that parameter. I dont suppose you know if it defaults to that value do you?
Do I still need to create the tablespaces before trying to import or do I just import and that creates them?
I think problem stems from the fact that the export was...
I have an 8GB .DMP file which I can not recreate.
I have a server with Oracle 8 server and 45GB of free space to play with.
I have tried to create a database and import the file. That is where it all goes wrong. It has problems allocating intial extents for some tables. I am not a DBA but I need...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.